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) >>

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.