What is the best GUI for managing MySQL 5.1 installation? Would like something as close to SQL Server's management tools as possible as that's where my experience is. The management client would need to run under Windows (XP, Vista (32 and 64-bit flavors), and 7 (32 and 64-bit flavors).
+2
A:
If you also have a PHP/Apache server, you can user phpMyAdmin or SQL Buddy. Otherwise, the MySQL GUI Tools (Query Browser and Administrator) are good.
John Paulett
2009-11-09 02:03:44
Another vote for phpMyAdmin. The big advantage is it's very popular, so chances are you'll use it at some point anyway. Why not start now and get over the (fairly small) learning curve.
Goose Bumper
2009-11-09 03:02:23
A:
So far the closest thing I've found is Navicat Lite http://www.navicat.com/
Aaron
2009-11-09 02:03:53
MySQL Query Browser is also very useful when you're just doing some SELECTs.
Jed Smith
2009-11-09 02:13:45
+2
A:
I have been using SqlYog for about several years now and am very happy with it. It has the best interface I have seen. Navicat is good, but SqlYog is better. Plus there are several "power" features that come in handy like the query builder tab.
The Pro version is about $70 but there is a free community version.
Ken
2009-11-09 02:05:46