常见问题: 

1、没有授权,

MySQL远程连接数据库-LMLPHP

解决办法 :grant create,drop,update,insert on t2.8* to root@'192.168.111.129' identifid by "123456";

flush privileges;          #刷新权限

grant all on t2.* to root@'192.168.111.129' identified by "123456";   #对所有的库授权

grant all privileges on t2.* to root@'192.168.163.130' identified by '123456';

05-16 09:46