For those MySQL developers who miss the old good MySQL Front, there is a new alternative, they will feel very good working with this new database manager.
SQLyog really surprised me. This software features the simplicity of MySQL Front, with the power of EMS MySQL Admin. This is definitely one of the best database managers for MySQL I ever seen.
Working with it is fairly easy, you will see one icon aside of each option, so it's easier to identify and locate. The GUI is very clear and understandable, and using a desktop application is a little bit faster that using a web based db manager like phpMyAdmin.
Manage multiple servers, databases, tables, indexes, stored procedures...
Perform complex SQL queries, execute scripts, and more.
One of the best features I asked it's present!: A "history" tab, to see, copy and reproduce all the executed queries! (from scripts or from the program itself).
Somehow it resembles Microsoft Query Analyzer a lot! Very suspicious... :P
The reviewed version is the Community (free) version, so it lacks of some fantastic features that are (of course) only present in the "Enterprise" Edition ($99 single user).