1. Linux的防火墙问题,要打开MySQL的端口,方法见
2. 没有授权,需要为用户和ip一起授权
查看mysql数据库下的user表中,是否存在一条记录的host、user列是否为客户端的计算机名或ip、用户
SELECT host, user, password FROM user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA |
| % | root | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA |
|192.168.0.9 | root | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA |
+-----------+------+-------------------------------------------+
以第三条记录为例:该记录表明ip为192.168.0.9的计算机上可以以root用户登录mysql服务器
授权方式为
grant all on 数据库名称 to 用户名@ip地址 identified by '密码'