Home > Database > Mysql Tutorial > mysql问题,ERROR 1130_MySQL

mysql问题,ERROR 1130_MySQL

WBOY
Release: 2016-06-01 13:45:30
Original
1016 people have browsed it

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
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template