Just saw your message and tried that too. Its good but its not as useful as SQL Server ones. Why? well using Navicat, you in a sense do write the query semi-manually. In fact, manually you can write even better queries. With SQL Server, main power comes with the where clause and conditions manipulation. Any idea?
The closest thing I have used to a MySQL GUI is phpMyAdmin. It works really well and just requires PHP.
I havent seen any mention of TOAD on here. Thought I would suggest that as it will do queries in a GUI for you and give you the SQL to cut and past as well as lots of other very nice features
As for me I prefer dbForge Studio for MySQL from Devart. This MySQL GUI Tool offers you a complete set of tools for server management and administration. To read more about this tool you can here. By the way it is possible to download and try the trial version.
I had to use this the other day while messing with a dedi. I can't say too much about it as I am fairly well programmed to use phpmyadmin but it will do the trick. It was recommended to me by the hosting folks. http://dev.mysql.com/downloads/workbench/ hope that helps, Nigel
I use the workbench software daily. Anyone who uses PHPMyAdmin to manage their databases is doing things wrong. Reasons not to use PHPMyAdmin: 1) Large amount of resources to simply access data 2) Interface limitations 3) Its slower (See #1)
You can try Valentina http://www.valentina-db.com/valentina-studio-overview, the program is free. It works on 3 OS: MAC, WIN, LIN. It works as with MySQL, so with PostgreSQL, SQLite and Valentina DB. I am very pleased with this program.
I would definitely recommend MySql workbench (http://dev.mysql.com/downloads/tools/workbench/). The opensource edition is free and very capable. I use it for my business and we manage millions and millions of database records. It also has a pretty decent database design and modeling tool.