mysql应许外部链接

1. SQL Error (1130): Host ‘192.168.1.88’ is not allowed to connect to this MySQL server  连接的用户没有远程连接的权限，只能在本机(localhost)登录

 

USE mysql
#需更改 mysql 数据库里的 user表里的 host项把localhost改称%
UPDATE USER SET HOST = '%' WHERE USER ='root';
FLUSH PRIVILEGES;