MySQL Forums
Forum List  »  MySQL Administrator

Re: MySQL Error number 2003???
Posted by: Julian Perelli
Date: August 18, 2009 12:30AM

Sorry, i'm writing 3 years later...

Now mysql seems to bind to 127.0.0.1 address, this way keeps only listening to connections that came from localhost, improving security.

So if you want to access from other computer through another address, let's assumme your mysql server has the 192.168.2.102 ip and you want to acces through the interface that has that address, then you have to edit your my.cnf loaded file (usually in /etc/mysql/my.cnf) and change:

bind-address = 127.0.0.1

for

bind-address = 192.168.2.102

or

bind-address = 0.0.0.0

this last to get it binded to all interfaces.

then restart mysql (/etc/init.d/mysql restart)

that's all...

Good luck!

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
Re: MySQL Error number 2003???
August 18, 2009 12:30AM


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.