mysql开启远程连接

1:有账号的情况下

use mysql;
update user set Host = '%' where User='root';
flush privileges;

2:无账号的情况下,grant 命令重新创建一个用户

grant all privileges on *.* to root @"%" identified by "root";
flush privileges;
posted @ 2023-11-16 09:30  朝阳1  阅读(10)  评论(0编辑  收藏  举报