mysql设置所有IP进行访问

1、登录数据库

[root@iZuf ~]# mysql -uroot -p****

2、切换数据库

mysql> use mysql;
Database changed

3、查看用户权限

mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | wjdb             |
| %         | wordpress        |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
| localhost | wjdb             |
| localhost | wordpress        |
+-----------+------------------+

4、修改用户表权限

UPDATE user SET Host= '%' WHERE User= 'root' LIMIT 1;

% 表示允许所有的ip远程访问，如果需要指定具体的某个ip就写上具体的ip即可

5、刷新权限

flush privileges;