Can you provide/recommend any tools for managing MySQL databases? There is a multitude of administration tools
ranging from ssh'ing into the server and directly issuing commands to
commercial GUI software. phpMyAdmin is very commonly used because it's
easy to use and can manage your database through a web page. It is also
a fairly large security liability so restrict access to phpMyAdmin to
only those networks you'll be managing your server from.
MySQLadministrator is also available from mysql.com as a Windows or
Linux binary and is freely available.