Mysql Control Center was the tool that I used on Windows to manage my MSQL DB's but it had a Major drawback - as with most things running on Windows - it had no support for UTF-8. CocoaMYSQL is one of those tools which after a while of using makes you wonder how on earth did you manage to survive without it up until now.
CocoaMYSQL has not been updated for about 2 years but don't let that put you off - it is packed with a ton of coolsome features such as the ability to import and export MYSQL dumps, and do pretty much anything you like with tables and DB's.
I use CocoaMYSQL to manage my blogg and pretty much the whole site - its the best thing since sliced cucumber.
Now connecting to your localhost is easy, but what if you want to connect to your remote server? Well first off you need to do the following after you have SSH'ed into your server.
GRANT ALL ON *.* TO username@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; ->FLUSH PRIVILEGES
Replace the username and password. Then add the following to your my.cnf file on your server...
bind-address = 127.0.0.1
port = XXXX
XXXX is an unused port of your choosing - this is the port that you will use in your connection settings.
1)
