这里为root账号开启远程访问权限

1：任意IP访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

 

2：特定IP访问，比如192.168.0.8

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.8' IDENTIFIED BY '密码' WITH GRANT OPTION;

3：刷新mysql系统权限

flush privileges