MySQL Workbench 1
MySQL is one of the most popular database servers on the planet. It's free, open source, and as powerful as any other database around. MySQL is also cross-platform; and, like with Linux, there is no built-in GUI tool for Windows. However, that's not really an issue because there are plenty of GUI tools available that can manage your MySQL database – even from the Windows environment. These tools can connect to both local and remote databases; so it doesn't matter of your MySQL server is on the Windows machine or a Linux server.
I have found five outstanding MySQL managers for you to examine. Of these five, you will certainly find one that will help you manage all aspects of your MySQL databases.
1. MySQL Workbench
MySQL Workbench is the de facto standard for MySQL database management. This particular tool is ideal for DBAS to aid with: Database Design & Modeling, SQL Development (replacing MySQL Query Browser), and Database Administration (replacing MySQL Administrator).
Credit: Images by Jack Wallen for TechRepublic
Jack Wallen is an award-winning writer for Techrepublic and Linux.com. As an avid promoter/user of the Linux OS, Jack tries to convert as many users to open source as possible. His current favorite flavor of Linux is Bodhi Linux (a melding of Ubuntu and Enlightenment). When Jack isn't writing about Linux he is hard at work on his other writing career -- writing about zombies, various killers, super heroes, and just about everything else he can manipulate between the folds of reality. You can find Jack's books on Amazon, Barnes & Noble, and Smashwords. Outnumbered in his house one male to two females and three humans to six felines, Jack maintains his sanity by riding his mountain bike and working on his next books. For more news about Jack Wallen, visit his website Get Jack'd.
Take a look on free tool Valentina Studio, is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases for free on 32/64 bit Windows, Linux and Mac OS X. http://www.valentina-db.com/en/valentina-studio-overview
Quite a disappointment at times. A table with the same column structure and indexes is completely different because a different username owns it between the two databases. Makes the migration and comparison rather useless.
Actually started with an earlier version and upgraded to this. I ended up downloading a tool from Redgate that did the comparison properly.