一、方式一修改user
-- localhost 改为 % 允许root远程登录
update user set host='%' where user='root';
二、方式二授权
#授权
mysql>CREATE USER 'root'@'%' IDENTIFIED BY 'root';
mysql>GRANT ALL PRIVILEGES ON *.*TO 'root'@'%';
#刷新权限
mysql> flush privileges;
修改root用户密码
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
刷新权限
mysql> flush privileges;