Mysql8.0开启远程访问权限

use mysql；  --登录后选择mysql数据库
select host,user,password from user;  --查看当前root对应host是否为 %
update user set host = '%' where user = 'root';  --更新
select host,user,password from user;
grant all  on *.* to 'root'@'%' with grant option;     -- 授权
flush privileges; -- 刷新权限