7 Applications to Make Working with MySQL Databases Easier article from Six Revision list following useful tools for working with MySQL, this order is based on my preference while using these tools
- phpMyAdmin
- DB Designer 4
- WWW Sql Designer
- Instant Sql Formatter
- MySql GUI tools
- EMS Sql manager for MySQL
- TurboDbAdmin
You can read about them at six revision’s article.
I have never used last two tools, instead I have used the Toad for MySQL. It has some nifty features. The one feature that I liked was the single click grouping feature of resultset. Though I still prefer to use phpMyAdmin.
Now to reason of this post, if you look at the list above, you will find the tools for general database management(like phpMyAdmin, EMS Sql Manager etc), ERD diagram creators(like DB Designer and WWW sql designers) and other log viewing and controlling tools(like mysql gui tools).
You might be wondering what is missing?