mysql 8.0.39 远程登录改表法

// 进入mysql

show databases;

use mysql;

show tables;

select user,host from mysql.user;

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

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xmy214';

FLUSH PRIVILEGES;