Geek Answers Handbook

Host ... ODBC connection error is not allowed when connecting to an online MySQL database

I downloaded the MySQL ODBC Connector 5.1. Now I am trying to configure DSN. But I get 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 is included in the TCP / IP server and port = 3306.

I also entered the user ID and password that I entered when opening www.myweb.com/cpanel

Is this a problem with the version? Should the version of MySQL on my server be 5.1, i.e. One of ODBC?

Please, help.

+5
source share
4 answers

Launch MySQL Workbench and Login

Go to "Users and Privileges"

%

+6

, .

(ODBC ) MySQL, . KB .

+1

cpanel has a remote MySQL option in the database, select this option. It will be redirected to “Remote access to the database database” by adding your IP address 117.xxx After adding your ip to the remote MySQL cpanel checks the connection ....

Note. If your ip is dynamic, delete the old ip and add the new ip to Remote MySQL in cpanel ....

+1
source

More articles:


All Articles