Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about what is MySQL Utilities. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

MySQL Utilities introduction

MySQL Utilities provides a set of command-line tools for maintaining and managing MySQL servers, including:

Administrative tools (cloning, copying, comparing, differentiating, exporting, importing)

Replication tools (installation, configuration)

General tools (disk usage, redundant indexing, search metadata)

MySQL Utilities is a series of command-line tools and Python libraries that make it easier to manage. The library is written in Python, which means that no other tools or libraries need to be installed. Currently, the design is based on the Python2.6 version and does not support the Python3.1 version.

MySQL Utilities provides software packages for various platforms. If you do not find a package corresponding to your own platform, you can compile and install it through source code.

The latest MySQL Utilities can be downloaded here: http://dev.mysql.com/downloads/utilities/

More introduction to MySQL Utilities: http://www.ttlsa.com/mysql/mysql-manager-tools-mysql-utilities-tutorial/

Http://blog.csdn.net/xlgen157387/article/details/52452394

MySQL Utilities dependent environment

MySQL Utilities needs

1. Python2.6 version, based on which all the code is written.

Different versions of python download address: https://www.python.org/ftp/python/

two。 You also need to connect to the generic version of the driver MySQL Connector/Python (above 1.0.8)

Download address: http://dev.mysql.com/downloads/connector/python/

Python installation

1. Download the Python installation package through wget

# wget http://www.python.org/ftp/python/2.6.6/Python-2.6.6.tgz

two。 Extract the file

# tar-zxvf Python-2.6.6.tgz

# ls

Python-2.6.6 Python-2.6.6.tgz

3. Configure the installation path

#. / configure-prefix=/usr/local/Python-2.6.6

4. Compile and install

# make

# make install

5. Configure soft links

# ln-s / usr/local/Python-2.6.6/bin/python / bin/python

# python

Python 2.6.6 (r266 84292, Mar 23 2017, 17:55:01)

[GCC 4.4.7 20120313 (Red Hat 4.4.7-3)] on linux2

Type "help", "copyright", "credits" or "license" for more information.

> > >

MySQL Utilities source code installation

# wget-c https://cdn.mysql.com//Downloads/MySQLGUITools/mysql-utilities-1.6.5.zip

# unzip mysql-utilities-1.6.5.zip

# cd mysql-utilities-1.6.5.zip

# python. / setup.py build

# python. / setup.py install

You may be asked to install the driver Connector/Python first

Command test:

# mysqldiskusage

WARNING: Using a password on the command line interface can be insecure.

# Source on localhost:...

Usage: mysqldiskusage-server=user:pass@host:port:socket db1-all

Mysqldiskusage: error: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)

#

The above is the editor for you to share what is MySQL Utilities, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.