Page 1 of 1

MySQL bind-address failure

Posted: Fri Aug 21, 2009 3:05 pm
by alex.barylski
I am trying to connect to a remote MySQL server from my Windows machine. I have done this a 100 times in the past and never had this issue.

Basically when I change bind-address to anything other than 127.0.0.0 and restart the MySQL server it fails on me but keeping it as the local loopback address works fine. I have tried using wildcards % and * as well as the IP of the Windows machine I am trying to connect from (ie: 192.168.1.104).

The error and log files appear to be empty (ie: mysql.err)

Any ideas on what might be causing this issue?

Re: MySQL bind-address failure

Posted: Fri Aug 21, 2009 3:10 pm
by alex.barylski
I don't believe a firewall is the cause here, as both computers are behind the same router.

Code: Select all

/etc/init.d/mysql restart
Is what I used to restart the MySQL server
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
This is the error I receive when I start the server with anything other local loopback address as bind-address value???

Re: MySQL bind-address failure

Posted: Fri Aug 21, 2009 5:19 pm
by VladSun
What happens if these lines are commented out:

Code: Select all

#bind-address = 127.0.0.1
#skip-networking
?

Re: MySQL bind-address failure

Posted: Sat Aug 22, 2009 12:43 pm
by alex.barylski
skip-networking doesn't exist and bind-address...well I just restarted and everything seems OK...