By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Mysql Error while connection from remote ip on linux

P: 1
I'm getting a problem while connecting to mysql database from remote host on linux environment. I'm also able to ping mysql server machine and i'm trying to login using below command:

mysql -u root -s -h ip_address_of_the_mysql_server(in my case the ipaddress is network ipaddress)
IT is giving below error:

ERROR 1130 (00000): Host '' is not allowed to connect to this MySQL server..

Pls give the solution, if any body have an idea for the same.

Thanks & Regards,
Ajay Patil
Feb 18 '12 #1
Share this Question
Share on Google+
1 Reply

P: 13,264
Straight from the MySQL refmanual
it means that there is no row in the user table with a Host value that matches the client host:

Host ... is not allowed to connect to this MySQL server

You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect.

If you do not know the IP address or host name of the machine from which you are connecting, you should put a row with '%' as the Host column value in the user table. After trying to connect from the client machine, use a SELECT USER() query to see how you really did connect. Then change the '%' in the user table row to the actual host name that shows up in the log. Otherwise, your system is left insecure because it permits connections from any host for the given user name.

On Linux, another reason that this error might occur is that you are using a binary MySQL version that is compiled with a different version of the glibc library than the one you are using. In this case, you should either upgrade your operating system or glibc, or download a source distribution of MySQL version and compile it yourself. A source RPM is normally trivial to compile and install, so this is not a big problem.
Feb 21 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.