远程登陆mysql报错：ERROR 1130 (HY000): Host '10.0.0.8' is not allowed to connect to this MySQL server

问题原因：在数据库迁移到mysql主机后远程登陆mysql报错：

ERROR 1130 (HY000): Host '10.0.0.8' is not allowed to connect to this MySQL server

 

解决方法：切换到mysql主机进入mysq后刷新mysql数据库

mysql> FLUSH PRIVILEGES;

 再次切换回后成功远程登陆成功：

感谢网友的解决办法：http://blog.csdn.net/bingjianit/article/details/54384299