I've been doing a lot of work with MySQL lately. A lot more than I ever have. As a normal fan of open source software, I am pleased to have such a feature rich database at my disposal. I do have one small problem that bothers me, however...
The various IDEs I have tried are really far behind the mark. I do not feel as productive when working on MySQL as I do when working on MSSQL. Rarely do I heap praise on Microsoft, but man do they know how to design and deliver an IDE.
To start off with, I tried the MySQL administration tool. I found it very clunky and upsetting to work with. I then found SQLyog, which is a lot more refined, but isn't quite there yet. I like how fast the editor performs but there are still moments with SQLYog confuses me. Favorite past times we share include obfuscating the values of Bit Columns in the Table Data Tab and Randomly Deleting Views.
Thusly, I am on the lookout for a top quality MySQL database administration tool. If you know of something applicable that you like to use, please share it with me in comments below. I run both Windows and Mac computers so only products with solutions for both platforms will be considered.