MySQL默认是没有开启远程访问控制的。
创建远程访问用户账号。操作步骤如下:
1 grant all privileges on *.* to root@'192.168.100.101' identified by '123456' with grant option;
flush privileges;
//grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";
2 若不限制连接的IP,则设置为 ‘%’即可。
grant all privileges on *.* to root@'%' identified by '123456' with grant option;
3 ubuntu系统下,需屏蔽对本地监听。
文件路径:/etc/mysql/my.cnf
将bind-address=127.0.0.1前加#,即
#bind-address=127.0.0.1
4 增加用户,分权限。
增加一个用户haha,密码为123456,让他可以在192.168.101.172主机上登录,并对数据库info有查询、插入、修改、删除的权限。
create user haha@'192.168.101.172' identified by '123456' (添加用户haha)
grant select,insert,update,delete on info.* to haha@'192.168.101.172' identified by '123456';