Mysql 允许IP访问

1： 创建user用户

CREATE USER demo IDENTIFIED BY “123456”

2、

mysql>GRANT ALL PRIVILEGES ON shandong.* TO 'demo'@'%'WITH GRANT OPTION

//赋予任何主机访问数据的权限，也可以如下操作

GRANT ALL PRIVILEGES ON shandong.* TO 'demo'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;

grant all privileges on *.* to root@"%" identified by "password" with grant option;

flush privileges;

3、

mysql>FLUSH PRIVILEGES

//修改生效

4、

mysql>EXIT

//退出MySQL服务器，这样就可以在其它任何的主机上以demo身份登录

ubuntu 下需要打开端口

sudo nano /etc/mysql/my.cnf

bind-address = 127.0.0.1

改为：

bind-address = 0.0.0.0