修改mysql远程连接
来源：未知 责任编辑：责任编辑 发表时间:2014-03-23 22:31 点击:次
--修改用户远程连接权限
update user set host = '%' where user = 'root';
select host, user from user;
--开启远程连接
grant all privileges on *.* to 'root' @'%' identified by 'root';
flush privileges;
注:mysql密码必须为root
update user set host = '%' where user = 'root';
select host, user from user;
--开启远程连接
grant all privileges on *.* to 'root' @'%' identified by 'root';
flush privileges;
注:mysql密码必须为root
相关新闻>>
- 发表评论
-
- 最新评论 进入详细评论页>>
