MySQL 5.7数据库可以用任意IP连接访问

1. 登录mysql:
mysql -u root -p

2.查看mysql数据库:
use mysql;
 

3. 输入:
select user,host from user;

4. 更新如下即可(百分号不能发布):

update user set host='%' where user='root';

FLUSH PRIVILEGES;

5.查看:
select user,host from user;

6.重启数据库:
service mysqld restart