透明网关 配置DSN测试时报错:
Connection Failed
[MySQL][ODBC 5.3(a) Driver ]Host ‘主机名’ is not allowed to connect to this MySQL server:
可能原因:
1)安装MySQL 时未勾选”Enable root access from remote machines”
2)数据库权限问题:表示该对象不是远程对象,不能通过该对象远程访问数据
解决办法:
1)首先确定,防火墙允许端口号通过;
2)设置权限:(分三种)
(首先,通过 D:......路径\bin > mysql -uroot -p 进入MySQL数据库)
① 任何地点,任意操作;
Grant all privileges on *.* to ‘用户名’@’%’ identified by ‘密码’ with grant option;
② 特定IP,任意操作;
Grant all privileges on *.* to ‘用户名’@’192.168.1.110’ identified by ‘密码’ with grant option;
③ 特定IP,特定操作;
Grant insert, update,delete ,select on *.* ‘用户名’@’192.168.1.110’ identified by ‘密码’ with grant option;
3)重载授权表:(即刷新特权,必须的,否则不成功)
4)退出MySQL数据库:exit
5)查询权限:
Select host ,user ,password from user;
可以修改:
Update user set host =’%’ where user =’root’;
报错:ERROR 1062<23000>: Duplicate entry ‘%-root’ for key ‘primary’;
已经存在user为root,host为%的权限了。
错误:
Connection Failed
[MySQL][ODBC 5.3(a) Driver]Access denied for user ‘用户名’@’主机名’ (using password :YES)
这个只能是用户名或者密码错误,没有别的。
报错:
Connection Failed
[MySQL][ODBC 5.3(a) Driver]Can’t connect to MySQL server on ‘IP地址’(10061):
是因为MySQL服务器没开。
错误:
Connection Failed
[MySQL][ODBC 5.3(a) Driver]Host ‘主机名’ is blocked because of many connection errors:
Unblock with ‘mysqladmin flush-hosts’:
原因:同一个IP在短时间内产生太多中断的数据库连接而导致的阻塞;
解决:修改my.ini 中的max_connection_errors进行设置MySQL等待与连接时长即可解决。
1)如果有修改权限,则可以在MySQL的安装路径下,修改my.ini 中的max_connection_errors=10000,然后重启MySQL;
2)没有权限,可以在cmd中设置:
D:\......安装路径\bin >mysql -uroot -p
Mysql > set global max_connect_errors=10000;
(可以解决问题,但是不治本!)
3)尝试设置MySQL连接等待时长 wait_timeout 设置同样在my.ini 中找增加 wait_timeout=5;