mysql1130错误

连接局域网上的MySQL时报错：

ERROR 1130 (HY000): Host ‘192.168.2.1’ is not allowed to connect to this MySQL server

解决办法

cd C:\Program Files\MySQL\MySQL Server 5.5\bin

mysql -uroot -p
use mysql;

update user set host =’%’ where user=‘root’;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’;
FLUSH PRIVILEGES;
\q