By far Navicat. Created by Premium Soft, its on 30 days trial, but you will buy it for 60$ after that.. Its godly.
PHPMYADMIN has lots of limitations... namely requiring PHP and a webserver to be installed. Its slow as well.
I vote for SQLYog as well. Really nice to work with. Also some cool (but maybe not all THAT useful) features - : for example in query result grid it detects if binary data is an image - and shows the image in the grid. Amuses a developer like me to see things like that
The best free gui tools are the ones MySQL gives you for free. Just go to the downloads on MySQL.com and get the MySQL GUI Tools.
SQLYog is what i would go with , this morning after 2 years of using this free version i went for purchasing commercial version. Roxy
I use the MySQL suite available free from their site. Mostly MySQL Query Browser and MySQL Administrator. Other than that I fallback to TOra if I want to edit some junk inline. I'm not a big fan of phpMyadmin.
MySQL Front provides lots of other features missing in SQLYog Please have a look http://www.mysqlfront.de/download.html
HeidiSQL is a good, light weight and free tool for Windows. Other good tool is Toad for MySQL. phpMyAdmin is really good in web based GUIs. A list of most commonly used MySQL GUIs can be found here.
The best mysql GUI tools is dbForge Studio for MySQL 4.0 Visual database diagram, Mysql Debugger stored procedure and scripts. See Review of dbForge Studio. mysql-tools.com/en/overview-mysql-tools/2-devart-dbforge/39--dbforge-studio-for-mysql-overview.htm
Anyone know of a mySQL GUI tool that has the capability of making views from GUI? Just like SQL Server, you can make a view from GUI and instead of coding joins - just do it from GUI. I always prefer coding that GUI tools but for views and join, it comes handy.