Anyone who has read (and paid attention) to my blog knows that I use MySQL. Personally I love the free database, so far I haven't met any project it couldn't handle. Where I think it has been let down is by its GUI tools. Though they have been there by either MySQL themselves or a 3rd party they always seem flaky, or never quite logical. This is especially true for MySQL recent re-incarnations of their GUI tools package.
I can second Aqua Data Studio...it's been a godsend the last few weeks while working with a nasty Oracle database designed by...well...no thinking human would have designed it. Let's leave it at that.
The features are outstanding, though performance was sometimes a little sluggish. I'm not complaining though. I'm a huge fan!
@Rob, The performance on my machine (MBP with 2gb RAM) is fine, no complaints, and yes I think its Net Beans based
@Nick, cheers for the link. Toad is Windows only though (I thought any). SQLYog (What a weird name) I never got into, I always thought the interface wasn't intuitive enough. As for MySQL own tools, hopefully one day they will be stable and feel less like a pre version 1 release.
Andy, if you are using mySQL I also use CocoaMySQL from http://cocoamysql.sourceforge.net/ Its pretty neat as you can also do data entry into the tables (not just parse some SQL)
I've been using <a href="http://http://www.navicat.com/" title="Navicat">Navicat</a> at work and it's been really great, but now that I've seen some of the other posts I'm eager to check them out as well.
PS: I realize this post is quite old, so really I just wanted to thank you guys for the mysql gui leads =)
hi friends, sqlyog runs fairly well with all Windows version from 98SE to Vista. Runs on Linux with WINE and is worth . i was recommended by most of my colleagues and friends. So, i had look into it its just simply rock. you try !!!