主机...不允许在ODBC连接中出现错误，而连接到在线MySQL数据库 [英] Host...not allowed error in ODBC connection, while connecting to an online MySQL database

问题描述

我已经下载MySQL ODBC Connector 5.1。现在我想设置DSN。但是得到的错误：

连接失败：[HY000] [MySQL] [ODBC 5.1驱动程序]主机'117.xxx'不是允许连接到此MySQL服务器

我的服务器url是server.myweb.com - 这个名字进入TCP / IP服务器， Port = 3306。

我也输入了用户ID和密码，这是我打开www.myweb.com/cpanel时输入的密码

这是一个版本问题吗？如果我的服务器上的MySQL版本也是5.1，即ODBC？

请帮助。

解决方案

运行MySQL Workbench和登录

转到用户和权限

选择与主机匹配的用户和更改限制连接到％

并保存更改

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

这篇关于主机...不允许在ODBC连接中出现错误，而连接到在线MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！