mysql远程连接问题
时间：2008-03-20 来源：剑心通明
mysql -h 192.168.11.2 -u root -p
Enter password: ********
ERROR 1130 (00000): Host '192.168.11.2' is not allowed to connect to this MySQL server
解决办法，在192.168.11.2机器上执行
mysql>grant all on *.* to root@'%' identified by 'yourpassword';
mysql>flush privileges; //刷新权限
Enter password: ********
ERROR 1130 (00000): Host '192.168.11.2' is not allowed to connect to this MySQL server
解决办法，在192.168.11.2机器上执行
mysql>grant all on *.* to root@'%' identified by 'yourpassword';
mysql>flush privileges; //刷新权限
相关阅读 更多 +
