# MySQL Utilities

MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. These utilities encapsulate a set of primitive commands, and bundles them so they can be used to perform macro operations with a single command. They can be installed with MySQL Workbench or as a standalone package.

They are a set of command-line utilities and a Python library for making the common tasks easy to accomplish. The library is written entirely in Python, meaning that it is not necessary to have any other tools or libraries installed to make it work. It is currently designed to work with Python v2.6 or later and there is no support for Python v3.1.

The utilities are available under the GPLv2 license, and are extendable using the supplied library.

# Installing The MySQL Utilities

MySQL Utilities development is managed elsewhere, and requires a separate download. Attempting to start the MySQL Utilities when they are not installed will prompt for a download and their installation. See the MySQL Utilities manual for additional information.

Note

MySQL Workbench searches for the mysqluc MySQL Utility in the system PATH to determine if the MySQL Utilities are installed.

# Opening MySQL Utilities From MySQL Workbench

To open the MySQL Utility mysqluc (MySQL Utilities Unified Console) from MySQL Workbench, click Tools and then Start Shell for MySQL Utilities from the menu. The following output shows the MySQL Utilities console window with the help command executed.