Wednesday, July 11, 2012

MySQL Error number 2003?



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