91 words
1 minute
Mysql数据库root开启远程连接
2025-08-04

1. Mysql服务启动#

1.1 输入命令回车输入密码可以正常连接#

mysql -u root -p

1.2 查询所有数据库#

show databases;

1.3 切换到mysql数据库#

use mysql;

1.4 查询host#

SELECT host, user FROM user WHERE user = 'root';

1.5 更新任意ip都可以连接#

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

1.6 刷新权限使配置生效#

flush privileges;
Mysql数据库root开启远程连接
https://fuwari.vercel.app/posts/mysql数据库root开启远程连接/
Author
Published at
2025-08-04
License
CC BY-NC-SA 4.0