Navicat for MySQL for Mac

You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

A while back I wrote a review for v9 that mentioned it was buggy, so I thought I should follow-up to say that I have found v10 to be rock solid. HUGE improvement in reliability in this release. Since I didn't mention it before I should point out one of Navicat's features that if you use it once will make the app worth the price: If you open a connection to two databases at the same time, you can migrate your tables (and views, procedures, etc) just by drag & dropping them from one db to the other. Boom. Done. No exporting & import. It's barely more difficult that moving a file across a network. Amazing. The other parts of the app continue to be refined, making editing tables, and stored procedures just a *little* bit nicer. And I know it's been there for a while, but the SSH tunnelling feature is enormously handy when trying to access a database behind a firewall. Thanks Navicat devs!

There are a number of decent and *free* database management programs out there but I found Navicat to be well worth the money. (You might think it seems like a lot but if you're spending even a few hours/week managing a DB I think Navicat is good value.) Unfortunately I'm stuck on version 8 because while the interface on 9 is much nicer, I find it crashes pretty much every time I use it. Sometimes it's because of a timeout on the server, sometimes it's just seems random. There seem to be a few buggy interface elements that pop up from time to time as well (the enum default-value menu comes to mind -- it often chooses the values of the previously selected enum field). So I'll stick with 8 for now. Hopefully 9.2 brings some stability.

Crazy stuff! I've been using Navicat for a long time now, and it proven itself an indispensable tool for managing MySQL databases. And I have lots and lots of them. Navicat does absolutely everything I need. Transfers, queries, data/structure sync, SSH/HTTP tunneling.. And support is beyond incredible! I files a crashing bug to them and got it fixed, AND the updated version of the program released in under 48hrs. I'm shocked! It is indeed an expensive tool, but considering how much time it'll save you in a long run, and hourly rate of almost any DBA/programmer who do DBs for living, the price is rather easily justifiable. Highly recommended.

This is THE product to own if you're doing MySQL work. No more myPHPAdmin crap. The power to not only create the database, but to managed it with micro edits right in the GUI is unmatched. Heavily recommend for those of you who know that time does equal money. ;-)