[thelist] MySQL GUI Interfaces

[DESCHAMPS Stéphane DvSI/SICoR]

> Currently I am using MySQLGUI 1.7.5-1 on my Linux box, and
> while it is a
> timesaver I am in need of more power and flexibility. Knowing
> that you all
> would know what works I seek your input (gawd, I am formal
> this morning!
> :-) ). I have looked at many MySQL GUI's, I just need some
> recommendations
> during this time of me not having much time to test and pick a new
> interface.
>
> I need a GUI with the following features -
> * Can be either Linux based or Windows based.
> * Must be able to connect easily to multiple MySQL databases
> on multiple
> servers without having to change an 'options' setting.
> (similar to MS SQL Server Enterprise Manager)
> * Must have the ability to run lengthy SQL scripts without
> choking (MySQLGUI
> will not). I know that I can do this from the command line, which I do
> frequently, but if the GUI has syntax checking it would help
> vastly, you
> know how frustrating a syntax error can be to track down.
> * If it has an easy to manage GRANTS feature that would be a big plus.

Jay,

Apart from the syntax checker, phpMyAdmin is a web-based, PHP-based GUI
which I use and find pretty good. It's not system-based, it can connect to
several databases (I haven't tested it but the conf files seems like it's
possible), and you can manage users and grants.

You know it, I'm sure, but for others out there who don't... I thought I'd
post this info.
http://phpmyadmin.sourceforge.net/

HTH
stef