I'm always getting Error 2003 when connecting to my newly set mysql database on a different server.
I found out the solution to this problem from Ubnuntu forums:
The default from mysql server is to be binding to localhost (127.0.0.1), this means it will only accept connections from local applications.
To change that:
edit /etc/mysql/my.cnf and comment out the line bind-address = 127.0.0.1:
Then you will need to restart the mysql server with:
/etc/init.d/mysql restart
That solved the problem.
No comments:
Post a Comment