1.设置密码
1
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
2.修改host
1
update user set host='%' where user='root';
3.刷新权限
1
flush privileges;
mysql8.0开启远程访问权限
本文由作者按照 CC BY 4.0 进行授权
1
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
1
update user set host='%' where user='root';
1
flush privileges;