Host...not allowed error in ODBC connection, while connecting to an online MySQL database
- by sqlchild
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.