I have a mysql running with bind-address "".

From the documentation, I understand it like, the server accepts connections only from the IP -

But I could able to connect to this mysql from another new server with the below configurations.

eth0      inet addr:  
eth1      inet addr:  
lo        inet addr:  

None of the above has the bind address in them, but how come I am able to connect to the service. Please clarify.

I am suing the below connections string from the new server.

mysql -u<<username>> -p<<password>>  -h<<hostname of the mysql running server>> -A

From the documentation, I understand it like, the server accepts connections only from the IP -

Your understanding is incorrect.

It has nothing to do with where the connection is coming from.

The server listens and accepts connections only on (not "from") the stated address. Where you can connect from is determined by the entries in the `mysql`.`user` table, which are created by GRANT statements, and, of course, whether you have network connectivity to the address where MySQL is listening.


Bind Address it's mentioned like If you intend to bind the server to a specific address, be sure that the mysql.user grant table contains an account with administrative privileges that you can use connect to that address. Otherwise, you will not be able to shut down the server. For example, if you bind to, you can connect to the server using all existing accounts. But if you bind to, the server accepts connections only on that address. In this case, first make sure that the 'root'@'' account is present in the mysql.user table so that you can still connect to the server to shut it down.

So, make sure that you have a account exists with 'mysql_user'@'' and then try to connect from other IP than Otherwise, you can report this issue to http://bugs.mysql.com/ mention specific MySQL version and OS details where your server is running

  • Your answer works for those who face connections denies alerts due to bind address but mine is different case. watch my question again. thanks.
    – Uday
    Dec 23 '13 at 6:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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