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-addresses

# bind-address		= 127.0.0.1
# mysqlx-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.

tcp6       0      0 :::3306                 :::*                    LISTEN      2248/mysqld