Connect MySQL From External Hosts

Edit the /etc/mysql/my.cnf file and change the bind-address directive to the server's IP address:

bind-address            = 127.0.0.1

After changing bind-address directive to server's IP address in /etc/mysql/my.cnf, MySQL daemon will need to be restarted using following command:

sudo service mysql restart