- /usr/local/mysql/bin/mysql -u root -p (进入mysql)
- use mysql;
- SELECT `Host`,`User` FROM user;
- UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
- flush privileges;
- 注意在mysql 命令行形式下一定要输入";".
- /usr/local/mysql/bin/mysql -u root -p (进入mysql)
- use mysql;
- SELECT `Host`,`User` FROM user;
- UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
- flush privileges;
- 注意在mysql 命令行形式下一定要输入";".