在使用MySQL-Front連接mysql的時(shí)候發(fā)生的這個(gè)錯(cuò)誤
ERROR 1130: Host 192.168.88.160 is not allowed to connect to this MySQL server
更改 mysql 數(shù)據(jù)庫里的 user表里的 host項(xiàng)
localhost改稱%
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
現(xiàn)在就可以連接了！
權(quán)限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' with grant option;