1修改my.cf
[mysqld]
bind-addresss = 192.168.0.1(绑定本机的IP)
重启mysql
2 在mysql库中加入权限
grant all privileges on *.* to 'username'@'%' identified by 'password' with grant option
%指允许所有主机ip连接,如改为对应的IP,则只允许单个IP
修改后flush privileges刷新主机权限
1修改my.cf
[mysqld]
bind-addresss = 192.168.0.1(绑定本机的IP)
重启mysql
2 在mysql库中加入权限
grant all privileges on *.* to 'username'@'%' identified by 'password' with grant option
%指允许所有主机ip连接,如改为对应的IP,则只允许单个IP
修改后flush privileges刷新主机权限