Database GUI

[DefecTalisman]

What is the best GUI to use for databases, specificly MySQL.
I have Database Workbench, also have Interbase and Firebird.
Interbase has its own GUI and could use for MySQL.

I have only ever done maintenance on Interbase and Firebird Db's and never started a database from scratch.

What do you use?

[halohalo]

I've had some success with using Quest Software's TOAD for Oracle, and was pleased to find out that they also have released a version of Toad for MySQL. It's freeware and you might want to check it out.

[deadimp]

I've been using SQLyog for a while now, the Community Edition (open source). The only annoying thing about that is the small splash screen it displays on startup, but other than that it's pretty easy to use.

[Dannz]

I use Navicat 6 for windows. Its a commercial app, but I got a full version on a PC Mag CD, which they do sometimes. They also do a 30 day trial version you can download. An easy way is to build the DB in something familiar like MS Access, and then can simply use Navicat to transfer over to the MySQL database. Usually once you have it set up, the tweaking around can be done in the PHP Admin. The 30 day Navicat trial should be enough to get the database up and going - and see how it compares.

Hopefully soon the MySQLdb module will be installed which gives the API to Python - I find this is by far the easiest, cleanest and most powerful scripting language. In fact you can do most of the admin from within Python.

[Micro]

MySQL Administrator is the way to go then. http://dev.mysql.com/

[Brandon]

Not sure if it can count as a GUI, but phpMyAdmin is the best for me.