Host...not allowed error in ODBC connection, while connecting to an online MySQL database

mysql odbc database-connection dsn
sqlchild picture sqlchild · Jun 2, 2011 · Viewed 22.6k times · Source

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.

Answer

Mauricio Palacios picture Mauricio Palacios · Feb 6, 2014

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

Related questions

Asterisk unable to connect to database using odbc connector

I am pretty new to Asterisk and this is my first attempt to connect to database (MySQL). But I keep getting this error [unixODBC][Driver Manager]Data source name not found, and no default driver specified. Here is my setup: /…

Read More
How to search for rows containing a substring?

If I store an HTML TEXTAREA in my ODBC database each time the user submits a form, what's the SELECT statement to retrieve 1) all rows which contain a given sub-string 2) all rows which don't (and is the search case sensitive?) …

Read More
How does OPENQUERY differ for SELECT and INSERT?

I'm aware that the following query will pull down the result set from a linked server: SELECT * FROM openquery(DEVMYSQL, 'SELECT event_id, people_id, role_id, rank, last_updated FROM event_cast') However, is this the same case when …

Read More