Home > Database > Mysql Tutorial > body text

mysql 异常搜集

WBOY
Release: 2016-06-07 16:26:52
Original
1327 people have browsed it

mysql 错误搜集 1. Error 1130 Host 'xxxxxx' is not allowed to connect to this MYSQL server 这种错误通常是没有权限,因为我是通过远程连接到数据库的 在服务端输入如下命令 grant all privileges on *.* to 'root@%' identified by '111111' with grant

mysql 错误搜集

1. Error 1130 Host 'xxxxxx' is not allowed to connect to this MYSQL server

这种错误通常是没有权限,因为我是通过远程连接到数据库的

在服务端输入如下命令

grant all privileges on *.* to 'root@%' identified by '111111' with grant option;
flush privileges;
Copy after login

?

2. Error 1145 Access denied for user 'root'@'network' (using password: YES)

这种错误是需要修改数据库密码

服务器端输入如下命令

set password for 'root@%' = password('111111');
flush privileges;
Copy after login

?

?

?

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