Home >Database >Mysql Tutorial >mysql解决远程不能访问的二种方法_MySQL
mysql解决远程不能访问的二种方法_MySQL
- WBOYOriginal
- 2016-06-01 13:24:081040browse
bitsCN.com
1、在/etc/mysql/my.cnf中的[mysqld]段注释掉bind-address = 127.0.0.1
2、用mysql -uroot -p 登陆mysql，然后采用以下方法开启远程访问权限：
方法1：mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>FLUSH RIVILEGES；
方法2：mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
bitsCN.comStatement：
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：MySQL的重装问题解决方法_MySQLNext article：MySQL笔记之数据备份与还原的使用详解_MySQL