Whether you like it or hate it, you may have to deal with MySQL at some point. A lot of users think the only way to manage those databases is from the MySQL shell within a terminal. Yes, that's one way. But there are also several tools available that can help you manage the MySQL databases. Let's take a look at five of them.
Note: If you'd prefer to view this information as a blog post, check out this entry in our Five Apps blog.
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.
Valentina Studio was updated to version 5, is free and supports MySQL, Postgre, SQLite and Valentina DB (object-relational, fast database). If you want some extra features like SQLDIFF, a Reports Designer for the free Reports Server, etc, then Valentina Studio Pro is also available. All on Windows, Linux and Mac OS X.
I have been using a product called Navicat for many years to manage MySQL databases, create and run queries etc. - it works brilliantly. As an added advantage it works with several other DBMS 's such as Oracle.
MySQL Workbench is good, and free, but dbforge is better and worth the money IMHO. Have used both and dbforge won me over two years ago.
Hi ! When we started using mySQL to develop a database, we chose the dbforge product (pro version) and have never regretted it. From managing the server & doing backups, schema & data sync between servers, writing queries using a GUI (like MS Access), procedures, events ... the fully Monty. And, they provide great user support - does Microsoft ever contact you because one of their applications crashed on your machine and you absent-mindedly clicked 'send log' ? These guys do !
This tool is indespesable to me. I use it to sync databases between my development system and the web host. I have used it to connect and sync MS Visual FoxPro tables to an MySQL database. This was scheduled to run at regular intervals as well.
What about SQL Navigator by Quest? I think it's a powerful tool that can be used with all kinds of databases ...
DBeaver is fast, feature rich, works with multiple DBMS from a single interface, multiple sessions, etc. I would say DBeaver is the KING for working with MySQL, I like it far better than MySQL Workbench. Surprised you did not mention it, since I learnt of it first from one of your earlier posts. I guess you are limiting this set to tools that work ONLY with MySQL?