Alternatives to MySql Query Browser?

Question

I have been using the MySql Query Browser and [opinion]it has to be the worst UI that I've seen for anything. Ever.[/opinion] But it's free, so it's great and I love it.

Can anybody recommend any better, free tools for MySql DB admin? I want it to run on my local machine and not in a browser, if possible...

Edit: I'm on Windows, but if something works on OSX, Windows and Linux, that would be great...

Edit: I chose a best answer based on my preference after testing. Navicat (PC, Mac, Linux) was best, HeidiSQL is great too (perhaps more complete, but the UI is a bit clumsier), and the rest are relatively annoying (again, for what I need in a UI)... this is pretty subjective, but I think if you try them all as I did, you'll agree with my top two choices.

Edit: After actually trying them out working, HeidiSQL is the best. Again, it's my opinion...

Answer 1

What platform do you intend this for?

There's sort of a rule that MySQL GUI clients must all be buggy, but navicat is still much more reliable than MySQL Query Browser in my experience. (Just get the free edition.)

Answer 2

Go for HeidiSQL. It's free, easy to use and does practically everything you may think of.

Answer 3

I second Navicat. The "Lite" version is free and it runs on Linux (via Wine), Mc and Windows.

Answer 4

I have used Toad for MySQL, I think it is pretty good (only Windows though).

Answer 5

I second HeidiSQL.

I wish I could first that... but well.

Answer 6

I get by with the community edition of sqlyog from www.webyog.com.

Answer 7

SQL Squirrel is a very nice Swing client for any relational database that has a JDBC driver. I think it's pretty good, and it's free.

Answer 8

Try the SQLYog MySQL GUI. The community edition is free and has proven to be more than adequate for what I need.

Answer 9

no doubt, I voted Navicat! I've been using it for 3 years and it's super! Now, it supports Oracle database and I just downloaded its trial version.

Answer 10

I bet Navicat is the best mysql gui!

Answer 11

Two very worthy contenders:

Oracle SQLDeveloper (yes, made by Oracle, but works with MySQL and is free)

DBVisualizer (paid version is superb esp. for keyboard-shortcut jockeys, but there is a free version too)

Answer 12

I use DbVisualizer Free edition. Cross platform, nice gui, easy to use.

Answer 13

Try RazorSQL. Cross platform (windows, os x, linux, solaris) and supports virtually any database and has all of the features of the more expensive tools.

Answer 14

On the Mac, Sequel Pro is a nice free tool. Querious also looks good, although it's still in beta (and not free).