Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
share|improve this question

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.

share|improve this answer
thanks michael.... pretty much clear – Uday Dec 24 '13 at 2:23

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 mention specific MySQL version and OS details where your server is running

share|improve this answer
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 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.