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?
MySQL bind-address failure
Moderator: General Moderators
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: MySQL bind-address failure
I don't believe a firewall is the cause here, as both computers are behind the same router.
Is what I used to restart the MySQL server
Code: Select all
/etc/init.d/mysql restartThis is the error I receive when I start the server with anything other local loopback address as bind-address value???Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Re: MySQL bind-address failure
What happens if these lines are commented out:
?
Code: Select all
#bind-address = 127.0.0.1
#skip-networkingThere are 10 types of people in this world, those who understand binary and those who don't
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: MySQL bind-address failure
skip-networking doesn't exist and bind-address...well I just restarted and everything seems OK...