设置mysql8的root可以远程访问

1 MySql-Server 出于安全方面考虑默认只允许本机(localhost, 127.0.0.1)来连接访问

2 修改root的密码符合mysql的默认规则

alter mysql 操作mysql系统表ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘W20289@’;

3 update user set host = ‘%’ where user =‘root’;

查看更新 ：select user,host from user，出现以下情况则可以远程访问

------------------+-----------+| user | host|+------------------+-----------+| root | % || mysql.infoschema | localhost || mysql.session | localhost || mysql.sys | localhost || wzh | localhost |+------------------+-----------+

4 flush privileges; //刷新

5 注意：如果是远程连接阿里云服务器的mysql，那么需要以下配置