Host is not allowed to connect ti this MySQL Server

cheesewizz · 11-04-2010, 10:22 PM

Hi All

Does anyone knows how to fix problem about database connection

I have a mysql server running on this IP 192.168.1.10
then i installed phpmyadmin as web interface

now one of my pc client tried to connection using MySQL Connector/ODBC

when he tried to test the error was appeared on the screen

Connection Failed: [MySQL][ODBC 5.1 Driver]Host'192.168.1.10' is not allowed to connect this MySQL Server

please need help

Thanks

quanta · 11-04-2010, 10:26 PM

What user does your client use to connect? Did you grant privileges for that host?

Code:

mysql> select user, host from mysql.user;

Noway2 · 11-05-2010, 04:21 AM

Just to add some clarification on Quanta's statement as I went round and round on this same issue for quite a while. The missing piece, for me, was to realize that MySQL authenticates not just the user but the user and the host. If you log in locally and look at the user table you will see this. For example, you will have root@localhost. You can specify the host that the user is allowed to log in from or you can wild card it with a % character.