Re: Host ... is not allow to connect to this mySQL server
Hi!!
{From docs}
If the following error occurs when you try to connect from a host other than the one on which the MySQL server is running, 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 hostname and username that you are using when trying to connect.
If you don't know the IP number or hostname of the machine from which you are connecting, you should put an row with '%' as the Host column value in the user table and restart mysqld with the --log option on the server machine. After trying to connect from the client machine, the information in the MySQL log indicates how you really did connect. (Then change the '%' in the user table row to the actual hostname that shows up in the log. Otherwise, you'll have a system that is insecure because it allows connections from any host for the given username.)
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 isn't a big problem.
For more check out this..
http://dev.mysql.com/doc/mysql/en/access-denied.html
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221