Mysql ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY

update user set host='%' where user='root';

select host,user,plugin from user;

+-----------+------------------+-----------------------+

| host | user | plugin |

+-----------+------------------+-----------------------+

| % | root | caching_sha2_password |

| localhost | mysql.infoschema | caching_sha2_password |

| localhost | mysql.session | caching_sha2_password |

| localhost | mysql.sys | caching_sha2_password |

+-----------+------------------+-----------------------+

ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY '密码';

刷新权限

flush Privileges;

'root'@'%' 中的 % 指的host。