禁止、允许MySQL root用户远程访问权限

关闭MySQL root用户远程访问权限:

use mysql;

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

flush privileges;

打开MySQL root用户的远程访问权限:

use mysql;

update user set host = "%" where user = "root";

flush privileges;

posted @ 2019-07-24 10:41  李小加  阅读(6707)  评论(0编辑  收藏  举报