1首先通过密码登录
2.

use mysql;

select host,user from user;

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

FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

之前也说过如何操作内容基本一致。最后条SQL就是在MySQL数据库中为root用户授予所有权限

方案2： https://www.172u.cn/news/671.html