MySQL bind-address failure

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

MySQL bind-address failure

Post 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?
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: MySQL bind-address failure

Post 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???
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: MySQL bind-address failure

Post by VladSun »

What happens if these lines are commented out:

Code: Select all

#bind-address = 127.0.0.1
#skip-networking
?
There 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

Post by alex.barylski »

skip-networking doesn't exist and bind-address...well I just restarted and everything seems OK...
Post Reply