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.

Let's face it, database-driven applications are the norm for so many applications. Especially when dealing with Web-based tools (such as CRM, HRM, ERP, etc) databases are a necessity. Because of this your databases must be in top shape. On the typical Linux machine you have two choices: Command line or GUI.

If you go the command line route with MySQL, you may have a long road to travel on the way to becoming a competent enough MySQL administrator to handle such tasks as performing backups, managing users and connections, and alike. Fortunately, there are GUI tools available to help you out with these tasks. One of those tools is the MySQL Administrator. This tool is a GUI tool that will make many of the more challenging tasks, well, not so challenging.

Specifications

Who's it for?

MySQL Administrator is for any administrator who needs to keep their MySQL database running as smoothly as possible, but doesn't want to have to depend upon the command line for these tasks.

What problem does it solve?

MySQL Administrator solves the problems usually associated with, what is often considered to be, the more complicated command line MySQL Administration administrative tools. With easy GUI configurations for tasks like MySQL startup parameters, database backup, and more, MySQL Administrator makes your database administrator life much easier.

Standout features

  • Simple to use GUI
  • Easy installation
  • DB health monitor
  • Replication
  • Easy user administration

What's wrong?

The biggest problem with MySQL Administrator is that you cannot create databases. Although there is an outstanding tool for this job (PhpMyAdmin), adding the ability to create databases from within this tool would make MySQL Administrator a one-stop shop for MySQL administrators.

Competitive products:

Bottom line for business

If you have to administer numerous MySQL databases you should do yourself a favor and give this tool a try. MySQL Administrator will enable you to easily monitor and manage all of your databases and database connections.

User rating

Have you encountered or used MySQL Administrator? If so, what do you think? Rate your experience and compare the results to what other TechRepublic members think. Give your own personal review in the TechRepublic Community Forums or let us know if you think we left anything out in our review.

Read our field-tested reviews of hardware and software in TechRepublic's Product Spotlight newsletter, delivered each Thursday. We explain who would use the product and describe what problem the product is designed to solve. Automatically sign up today!

Next Page (Photo Gallery) >>

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.