Computing

MySQL system error 111

2007-07-15

00:11:07 MySQL system error 111  

Categories: web, Linux, web servers, 97 words

I had some problems with a sql connexion returning the following error message:
"Lost connection to MySQL server at 'reading initial communication packet', system error: 111"

This was due to the server acepting only localhst connexions and the client to be on a remote host.

To fix this one needs to edit his "my.cnf" file (at /etc/my.cnf or /etc/mysql/my.cnf) and comment the "skip-networking" networking line and put the server IP address in "bind-address" as shown below:

# skip-networking
bind-address = 123.45.67.89 # server IP address

After the mysql server needs restarting:
/etc/init.d/mysql restart

Send feedback • Permalink

Trackback address for this post:

Comments, Trackbacks, Pingbacks:

No Comments/Trackbacks/Pingbacks for this post yet...

Leave a comment:

Powered by