MySQL Forums
Forum List  »  MySQL Administrator

MySQL Error number 2003 on Ubuntu 8.04
Posted by: Randall Shane
Date: June 10, 2008 09:04AM

If you're getting this error and find that you can login locally but not from any other machines, then the problem lies in the configuration file. By default, the my.cnf file has a line that reads:

bind-address = 127.0.0.1

This, by default, has the machine only listening on the localhost. You can check this using netstat -l -t -p. You should find an entry for mysql with TCP and *:mysql. If yours says localhost:mysql then you're only listening locally.

The fix is simple, comment out the line in the my.cnf file by inserting a # before it. That will fix it. With this, there was no need to make any adjustments to apparmor.

This took us 2 hours of researching & lots of cussing only to find it by accident. (That probably means its on page 1 of the documentation.)

Options: ReplyQuote


Subject
Written By
Posted
September 04, 2006 10:49AM
September 12, 2006 01:18PM
October 20, 2006 09:40PM
October 20, 2006 09:47PM
October 28, 2006 06:22PM
December 26, 2006 11:39AM
September 27, 2007 03:04PM
January 27, 2007 09:13PM
February 06, 2008 11:04PM
June 29, 2008 02:51PM
February 04, 2008 01:28AM
MySQL Error number 2003 on Ubuntu 8.04
June 10, 2008 09:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.