- 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;
来源: http://www.bubuko.com/infodetail-2930465.html