MySQL 开启IP远程访问

Mysql 8.0以后的版本

CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';  GRANT ALL ON *.* TO 'root'@'%';  ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码'; FLUSH PRIVILEGES;

Mysql8.0之前版本 

grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option

FLUSH PRIVILEGES;

用MySQL Shell 运行 上面的命令  CMD的话登录一下就可以了 具体 度娘