Home >Database >Mysql Tutorial >mysql问题，ERROR 1130_MySQL
mysql问题，ERROR 1130_MySQL
- WBOYOriginal
- 2016-06-01 13:45:301022browse
bitsCN.com
一直使用本机的mysql，
将数据库迁移到服务器上，报错：
ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server。
是因为Mysql默认安装只运行本机进行访问。
需要修改一下配置即可：
Java代码
mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
mysql>flush privileges;
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：mysql比较时间_MySQLNext article：mysql截取小数点后1位_MySQL