MySQL 远程连接[zz]

软件使用王杭州 6年前 (2019-04-09) 2402浏览 0评论 [编辑]

开启远程连接权限
use mysql;
select user,host from user;
update user set host=’%’ where user=’root’;
flush privileges;
select user,host from user;

关闭远程连接权限
use mysql;
select user,host from user;
update user set host=’localhost’ where user=’root’;
flush privileges;
select user,host from user;