Host...not allowed error in ODBC connection, while connecting to an online MySQL database
I have downloaded MySQL ODBC Connector 5.1. Now am trying to setup the DSN. But am getting the error:
Connection Failed : [HY000] [MySQL] [ODBC 5.1 Driver]Host '117.x.x.x' is not allowed to connect to this MySQL server
My server url is server.myweb.com - this name am entering in the TCP/IP Server and Port =3306.
I have also entered the userid and password , which is the one which i enter when i open www.myweb.com开发者_开发问答/cpanel
Is this a version problem? Should the version of MySQL on my server also be 5.1, i.e. the one of the ODBC?
Please help.
Run MySQL Workbench and Login
Go to Users and Privilegies
Select the User and Change Limit Connectivity to Hosts Matching with %
And Save the changes
It is not a version or ODBC problem. This error says there is no user with specified host name. Read more information in MySQL reference - http://dev.mysql.com/doc/refman/5.1/en/grant.html#grant-accounts-passwords
As others have said, this issue is not about the version of any component.
When clients (ODBC or otherwise) try to connect to MySQL, the server checks the username and password and the originating host identity against its permissions tables. This KB article may help you resolve the issue.
in cpanel under database there is an option "remote MySQL" select the option. It will redirect to "Remote database Access Host" add your IP '117.x.x.x' . After adding you ip to remote MySQL the cpanel check the connection....
Note- if your ip is dynamic remove the old ip and add the new ip to Remote MySQL in you cpanel....
精彩评论