Ubuntu allow Mysql connection access from outside

Posted under » MySQL on 25 June 2010

To allow remote connection to your mysql server you need to change your my.cnf.

2 things for this to happen.

enable external file locking so that you can edit but there is a chance of overwritting

# skip-external-locking

disable bind-address

# bind-address		= 127.0.0.1

Check to see if the disable is in effect.

netstat -lpn | grep 3306

If it returned this, it means you need to stop and restart

tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      6736/mysqld

If it returned this, everything is in order.

tcp        0      0 0.0.0.0:3306          0.0.0.0:*               LISTEN      7732/mysqld

 

web security linux ubuntu GIT svn Raspberry apache mysql php drupal cake symfony javascript Ajax css