Getting MySQL Workbench to work on a remote host

When you first install MySQL on Ubuntu 10.04 server it is configured to only allow connections from localhost and so if you want to connect MySQL Workbench to the server for administration purposes then you need to allow connections from any IP address. This editing the /etc/mysql/my.cnf file and find the section [mysqld] and edit the bind-address entry from 127.0.0.1 to be your full IP address or if you want to bind to all addresses then use 0.0.0.0. Also make sure that there is no skip-networking section.

And don't forget to restart MySql

sudo /etc/init.d/mysql restart

And grant privileges to root for remote administration, through the mysql console

grant all on *.* to root;

You will also need to add the MySql port to the firewall rules to allow access

sudo ufw allow 3306

Thanks to Vivek Gite over at nixCraft for his great artical on the same subject.

Comments

[Audemars Piguet 2008 Singapore InAugural watch uk]

contented mind is the greatest blessing a man can enjoy in this world.-Audemars Piguet 2008 Singapore InAugural watch uk