Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I trying to set alternate IP for gain access to MySQL Server (accessing from a PC with IP 192.168.1.20) in the file: my.ini

MySQL starts without problem, when in the configuration file, in the section mysqld I have:

[mysqld]
...
bind-address=0.0.0.0

But, does not starts when in the configuration file, in the section mysqld I have:

[mysqld]
...
bind-address=192.168.1.20 #Remote IP of Client PC

Showing the error code 1067:

With bind-address=0.0.0.0, all remote IP's are enable to gain access to my MySQL Server, I want to restrict only to 192.168.1.20.

How Can I fix this, or what is my mistake?

BR.

share|improve this question

1 Answer 1

You can't bind to a remote IP address because bind assigns the local address to a socket, which must either be a local address or a wildcard. I'm not sure what you're trying to do, but whatever it is, that's not the way to do it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.