Friday, May 7, 2010

MySQL server on Ubuntu or debian

To setup a mysql server on my ubuntu 9.10 box, I followed this guide:

But connecting from another host gave me the following error:

$ mysql -u mysqluser -p

ERROR 2003 (HY000): Can't connect to MySQL server on '' (111)

The above link indicates this is a network error.

Referring to the above link, I found to enable access I needed to edit /etc/mysql/my.cnf, specifically, change the bind-address from

#bind-address =
bind-address =

and restart mysqld:

$ /etc/init.d/mysql restart

Other useful MySQL links:

Adding users, etc.

MYSQL Docs - Access Privilege System


No comments:

Post a Comment