Open Source

Review: MySQL Workbench

The MySQL Workbench is an amazing single-point of contact for MySQL administrators, which can handle tasks both locally and remotely.

Recently the old guard MySQL GUI tools (MySQL Administrator and MySQL Query Browser) were issued the dreaded EOL (end of life). Initially I was taken by surprise, but when I was pointed to the single tool that was to take their place, I quickly realized that all would be well.

The MySQL Workbench is an amazing single-point of contact for MySQL administrators. MySQL Workbench can handle every possible MySQL task you need tackled both locally and remotely. But MySQL Workbench isn't just for data base administrators, it's also for DB developers and designers.

Specifications

  • Two versions: Community (OSS/GPL) and Standard (Commercial)
  • Minimum hardware:
    • CPU: Intel Core or Xeon 3GHz (or Dual Core 2GHz) or equal AMD CPU.
    • Cores: Single (Dual/Quad Core is recommended).
    • RAM: 4GB (6GB recommended).
    • Graphic Accelerators: nVidia or ATI with support of OpenGL 1.5 or higher.
    • Display Resolution: 1280×1024 is recommended, 1024×768 is minimum.
  • Supported operating systems:
    • Windows 7 (64bit, Professional or higher)
    • Mac OS X 10.6.1+
    • Ubuntu 9.10 (64bit)
    • Ubuntu 8.04 (32bit/64bit)
  • Additional vendor information
  • TechRepublic Photo Gallery

Who's it for?

MySQL Workbench is for anyone who needs to administer MySQL databases (from simple schema creation to more complex tasks such as model validation). But don't think you will be using command line tools. MySQL Workbench is a powerful GUI tool that will satisfy anyone needing a robust, user-friendly graphical interface to handle complex tasks.

What problem does it solve?

MySQL Workbench pulls together nearly every MySQL task and crams them all into one easy to use graphical interface.

Standout features

  • Simple installation
  • Multiple MySQL connections (both local and remote)
  • Unlimited undo/redo
  • Advanced find tool
  • Scripting and plugins supported
  • Reverse and forward engineering
  • Visual data (and schema) modeling
  • Server administration built in

What's wrong?

The initiated need not apply. With the tools Workbench is replacing, it was possible to only have a cursory understanding of MySQL to get by. You could create a database for use with tools like Drupal, for example. With MySQL Workbench, however, you better have a much deeper understanding of databases or you will have a tough time getting it to work properly. MySQL will now be lacking a graphical tool for new users.

Competitive products:

Bottom line for business

If you or your company depends upon MySQL databases, you need to take the time to familiarize yourself with the MySQL Workbench. Not only will this tool make your job easier, it will most likely introduce you to aspects of the MySQL database you never knew existed. The MySQL Workbench is an amazing tool ready to handle MySQL administration on every level.

User rating

Have you encountered or used MySQL Workbench? 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

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 jackwallen.com.

Editor's Picks

Free Newsletters, In your Inbox