jasun's blog

MySQL Maestro

I've just stumbled upon MySQL Maestro which is a Windows based application for MySQL management. I've only had a quick play with it, but it allows for remote user and database administration with a nice interface and plenty of options.

Compared to command line it makes certain tasks a lot easier to perform, for example looking up data in a certain field in a table as you don't have to remember the SQL commands to perform the task. Although you could allow users to use this application to access their databases, phpMyAdmin would be better suited for this as to allow a user to use MySQL Maestro you would have to either allow external connections to the MySQL server or allow interactive shell access.

For administration, you can allow the MySQL connection to be tunnelled over SSH so you would not have to open MySQL up to the outside as the connection to the MySQL server is made locally once an SSH connection has been established.

I think MySQL Maestro is a handy tool that will be of great use to people that would like to do easy MySQL administration from a Windows application. There are a number of other tools available as well which offer varied functionality. Used in combination with command line and web based applications such as phpMyAdmin MySQL Maestro is another good tool to help administrators complete MySQL related tasks.