MYSQL 8.0 修改远程连接

select host, user, plugin from user;

 localhost | root             | mysql_native_password 

//如果是 caching_sha2_password 修改为 mysql_native_password
alter user 'root'@'localhost' identified with mysql_native_password by '用户密码';
 
// 或
 
alter user 'root'@'%' identified with mysql_native_password by'用户密码';

//修改host地址 

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

FLUSH PRIVILEGES;