mysql连接远程数据库的问题

1.出现问题

ERROR 1130 (HY000): Host '192.168.6.95' is not allowed to connect to this MySQL server

数据库禁止此IP（192.168.6.95）通过此账号访问

需要在数据库中授权，登录数据库中执行以下SQL

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.6.95' IDENTIFIED BY 'root' WITH GRANT OPTION;

 

2.出现问题

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.2.239' (10060)

需要关闭防火墙即可