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:
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.