Home >Database >Mysql Tutorial >修改mysql远程连接_MySQL
修改mysql远程连接_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:43:56992browse
bitsCN.com
--修改用户远程连接权限
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 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql5.5 for linux 安装_MySQLNext article：mysql 主键自增长_MySQL