Open Source

Review: MySQL Administrator GUI toolset

MySQL Administrator is for any database administrator who needs to keep their MySQL database running smoothly, only without the command line.

Server Information

At a glance server information upon startup.

Startup process

All aspects of the MySQL startup process can be managed from this simple, tabbed interface.

Manage users

Adding a new MySQL user has never been easier. With this tool you can even give your new users specific privileges and limits.

Database health

At a glance database health monitoring. Here you can monitor connection and memory health as well as check status of all of the various MySQL variables that can be configured.

Backup

Try to backup a database from the command line with this kind of ease.

Add tables

At least you can add tables to your already existing databases. You can also edit and run maintenance on individual tables within a database.

About

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website getjackd.net.

7 comments
mbenegas
mbenegas

It is possible to create databases from within MySQL Administrator, just click on Catalogs menu option on the left hand, and right click the bottom panel, there you have the option to create a new database.

Kris.J
Kris.J

I've always installed phpMyAdmin - right after Apache and MySQL. Does Adminisrator/Workbench offer anything better or anything that I can't already do with phpMyAdmin?

Mark W. Kaelin
Mark W. Kaelin

What tools do you use to administer MySQL? Is there a product you would like to see us review?

jlwallen
jlwallen

shortly after i sent in this article i realized it did have the ability to do so - the ability is "hidden" because the databases are listed under "catalogs" and labeled "schemata". when you double click the "Catalogs" listing it will expand to show the Schemata (lower left pane). you can right click anywhere inside of that pane and select "Create Schema" to create a new database.

jlwallen
jlwallen

good to see that the MySQL developers are developing such a serious tool. the Workbench is certainly a do-all tool for dbas. The only problem I see is that it has a fairly steep learning curve.

hmszam
hmszam

In order for database management I use MySQL Administrator where to me it can preform MySQL Backup in compatibility mode which sometimes I need to restore it in our Windows Server when I backup in Linux Server. Beside I also use SQLYog where it similar to MySQL Query Browser (MySQL Administrator installation package). I like this SQLYog is due to the tools called Schema Synchronization Tools. This tools can easily synchronize the database structure without dropping the data in the table. Synchronization also and be done using Toad for MySQL (by Quest Software) but I like SQLYog the most.