There are a lot of MySQL managers which give you the ability to manage your MySQL online databases.
You can find a long list of them using google. Each one provides a lot of functionalities, and different approach, so you have to give a try to each one and then you can choose the best manager for you.
I've choosen different managers, and I use them depending from the platform I'm using, or the results I have to obtain. Sometimes a manager give me the ability to reach the goal in a very fast way respect to the others.
My preferred managers are the following:
Application | Platforms | Web | License |
MySQL Query Browser | Windows Mac OS X Linux |
http://dev.mysql.com | GPL License |
MySQL Administrator | Windows Mac OS X Linux |
http://dev.mysql.com | GPL License |
Ems MySQL Manager | Windows | http://www.sqlmanager.net/ | Freeware |
Sequel Pro | Mac OS X | http://code.google.com/p/sequel-pro/ | GPL v2 License |
phpMyAdmin | Windows Mac OS X Linux |
http://www.phpmyadmin.net/home_page/ | GPL v2 License |
Sometimes you could have the need to access your MySQL databases using http or ssh tunneling, this because for security reasons you provider doesn't give you the direct access to MySQL resources. So you have to connect your manager to your DB through an intermediate .php file.
In this case I use EMS MySQL Manager, it is easy to configure and provides a ready to use php script.
After you have installed EMS MySQL Manager copy the emsproxy.php file into your web server directory.
Open EMS MySQL Manager
Select Database->Register Database
Fill the Register Database wizard as follows:
Now click on the finish button, and wait for loading operations.
That's all!
You can now access your database through EMS MySQL Manager.
Gg1