select user, password, host from mysql.user;
、
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘147.114.169.197‘ IDENTIFIED BY ‘1‘ WITH GRANT OPTION;
update mysql.user set password=‘‘ where host=‘147.114.169.197‘;
flush privileges;
原文：https://www.cnblogs.com/xingchong/p/10306283.html