Point-and-Click MySQL Administration

Introducing MySQL Administrator, a graphical user interface database administration tool from MySQL AB, the makers of MySQL.

Jeremy Garcia

Thursday, February 1st, 2007

Share This:

While the MySQL database is extremely powerful, one common compliant– one loudly voiced by database administrators of other database products– is that MySQL administration is performed exclusively from the command-line. But to the contrary, MySQL does have a graphical user interface tool that’s supported by MySQL AB.

MySQL Administrator, available under the same dual-license as MySQL itself, is a powerful, visual administration console that provides significantly better visibility into how your databases are operating. It allows you to visually accomplish almost any task you can accomplish from the command-line.

One nice thing about MySQL Administrator is that it integrates database management and maintenance into a single application. You can configure servers, administer users, dynamically monitor database health, monitor replication status, perform backups and restores, and view logs.

You can download MySQL Administrator from http://dev.mysql.com/downloads/administrator.html. It’s available in both binary and source format.

Once the application is installed, start it by running:

 $ mysql-administrator

After you start MySQL Administrator, answer the prompts in the connection dialog box. If you need full access to a database, be sure to enter a set of credentials that have the proper privileges. After providing your credentials, hit OK to connect.

MySQL Administrator starts out with the Server Information pane selected. Server Information presents statistics about the MySQL server you’re connected to and the machine the database is running on, among other metrics.