在访问远程数据库时,报如下错误: ERROR 1130: Host ’192.168.1.3′ is not allowed to connect to this MySQL server
解决方法:
复制代码 代码示例:
/usr/local/mysql/bin/mysql -u root -p (进入mysql)
use mysql;
select ‘host’ from user where ‘user’='root’;
update user set host = ‘%’ where ‘user’ = ‘root’;
flush privileges;