mysql 允许ip访问

grant all privileges on *.* to 'root'@'ip' identified by 'password' with grant option;

flush privileges;

ip如为%，则允许所有Ip访问

 

8.0版本后，需要如下换成如下命令

create user 'root'@'%' identified by '123456';

grant all on *.* to 'root'@'%';

alter user 'root'@'%' identified with mysql_native_password by '123456';

flush privileges;

123456为密码