mysql 开启远程连接权限

最新推荐文章于 2025-04-18 16:48:19 发布

原创最新推荐文章于 2025-04-18 16:48:19 发布 · 151 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了解决MySQL服务器无法远程访问的问题。通过修改MySQL配置，将localhost更改为%，实现从任意主机通过root用户访问数据库。文章详细展示了更新权限及刷新权限缓存的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

远程连接服务器上的MySQL失败原因可能是：mysql没开启远程访问权限

解决方案

mysql> select host ,user, password from user;
+---------------+------+-------------------------------------------+
| host          | user | password                                  |
+---------------+------+-------------------------------------------+
| localhost     | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| vm-0-7-centos | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 127.0.0.1     | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| ::1           | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost     |      |                                           |
| vm-0-7-centos |      |                                           |
+---------------+------+-------------------------------------------+
6 rows in set (0.00 sec)

host、user字段标识了可以访问数据库的主机和用户。
将localhost修改成需要远程连接数据库的ip地址或者直接修改成%。
修改成%表示，所有主机都可以通过root用户访问数据库。
为了方便，我直接修改成%。

mysql>  update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select host ,user, password from user;
+---------------+------+-------------------------------------------+
| host          | user | password                                  |
+---------------+------+-------------------------------------------+
| %             | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| vm-0-7-centos | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 127.0.0.1     | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| ::1           | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost     |      |                                           |
| vm-0-7-centos |      |                                           |
+---------------+------+-------------------------------------------+
6 rows in set (0.00 sec)