Comment 3 for bug 155274

Revision history for this message
rshane (info-basexvi) wrote :

I found this error after an upgrade to 8.04 server. It seems the default my.cnf file is only listening on the localhost (use netstat -l -t -p to determine) & look for the mysql entry that reads:

tcp 0 0 localhost:mysql ...

If you have this, then you are only listening on the localhost. The fix was to comment out the line in my.cnf that reads bind-address = 127.0.0.1 byt prefixing the line with a #. This allows the machine to listen on the external ports as well. The netstat should show a line that reads as follows:

tcp 0 0 *:mysql ...

Hope this helps.