This program is compatible with cloud infrastructure and distributed computing, creating a distributed and secure system of MySQL clusters by supporting cloud servers.
Finally, MySQL Shell is an interactive administration tool that supports JavaScript, SQL, and Python modes.
Percona Toolkit automates repetitive tasks, speeds up your servers, and handles corrupt data. MySQL Utilities is designed to tackle day-to-day maintenance and administration. It comes with many tools for quick, easy management. It can manage multiple databases and boasts various CSS skins for easier management.Īlternatively, you can interact with MySQL through the command-line interface. It comes with an Apache License in the form of a PHP file. You can get Workbench in the Community and Standard editions.Īdminer is another one of many GUI tools in this program. Most popularly, MySQL Workbench is the official MySQL integrated environment, allowing you to administer databases and design their structures graphically.
This software features graphical user interface tools for managing your databases.
Learning how to use MySQL is simple for anyone who's ever tackled similar programs before, thanks to its straightforward user interface.
Version reviewed: 5.Once you install it, the program exists on your server and begins to store information. In fact, this is the official group of tools, since it has been made by the producers of the MySQL server. In conclusion: this is a powerful suite of tools for the administration of the database server.
Pluses: It is a full featured administration package using a GUI that makes the work a lot easier in most of the cases.ĭrawbacks / flaws: MySQL Workbench is a program that is still in the alpha phase so you might get unexpected behavior. After installing this tool, you have to configure some connectivity parameters such as the host, username, password and it starts monitoring your server depending on the monitoring parameters, which you have to set in its configuration panel. The last tool from this package is the MySQL Health widget. This feature list includes items like plug-in support, speed optimizations, or database synchronization. The producers promised some forthcoming features, which will make from this tool a much powerful one. The application it also features the support for SQL script export and reverse engineering of an existing schema.
You can get working within the application's interface with schema objects and documentation objects, separation of database catalog and model, relationships between tables based on foreign keys. It's a new tool, but the list of the features looks interesting. This release can be unstable and yes, it has bugs, so don't expect very much from it at this moment. MySQL Workbench is a tool that so far is in the alpha phase. Its functionality is limited to this one, but it should be enough for users who are accustomed with the SQL implementation of MySQL. This tool can run SQL queries over your databases. MySQL Query Browser it the tool that completes the MySQL Administrator's functionality. MySQL Administrator can also create/drop databases or modify the tables, but it doesn't have the possibility to run queries over the database. You can also backup or restore a database pretty easily with this program. This program displays the health of the running server as well as allowing you to read the logs of the server. With this tool, you can modify the service behavior, you can add or remove users (depending on your privileges), or you can manage the connections to the server. MySQL Administrator is a program that can modify various parameters of a MySQL database server. You can find in the DMG image the following tools: MySQL Administrator, MySQL Query Browser, MySQL Workbench, and a widget for your Dashboard named MySQL Health. MySQL GUI Tools is a set of programs that you can use to administrate MySQL database server.