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		=

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*               LISTEN      6736/mysqld

If it returned this, everything is in order.

tcp        0      0*               LISTEN      7732/mysqld


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