1、改表
在登入mysql后,更改 “mysql” 数据库里的 “user” 表里的 “host” 项,将”localhost”改称”%”
如下:
#mysql -u root -p
Enter password:
MySQL [(none)]> use mysql
MySQL [mysql]> update user set host='%' where user ='root';
MySQL [mysql]> select host,user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| 127.0.0.1 | root |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+---------------+
4 rows in set (0.00 sec)
MySQL [mysql]> quit;
Bye
[root@tests ~]# service mysql restart
Redirecting to /bin/systemctl restart mysql.service
最后修改服务器防火墙的出入规则,即可;
2、授权
如果你想myuser使用mypassword(密码)从任何主机连接到mysql服务器的话。
mysql>GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
如果你想允许用户myuser从ip为127.0.0.1的主机连接到mysql服务器,并使用password作为密码
mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'127.0.0.1'IDENTIFIED BY 'password' WITH GRANT OPTION;
最后刷新权限
mysql>FLUSH PRIVILEGES;
总结:两种方法,选一种操作即可。