Monday, February 19, 2007

Ubuntu MySql allowing TCP connections

A default setting for the Ubuntu mysql database is to not allow external TCP connections, to get this to work one needs to adjust the /etc/mysql/my.cnf file as follows:

$ sudo vim /etc/mysql/my.cnf

# change this line from 127.0.0.1 to your ip.
#
bind-address            = [your-server-ip]

# then just restart mysql server.
#
sudo /etc/init.d/mysql restart