1130 Host ‘localhost’ is not allowed to connect to this MySQL server，解决步骤

一级标题1130 Host ‘localhost’ is not allowed to connect to this MySQL server，解决步骤

六级标题第一步：在mysql的安装目录下找到 my.ini文件用记事本打开

六级标题第二步：在[mysqld]下粘贴

skip-grant-tables

六级标题第三步：重启数据库(用管理员身份运行命令提示符)

六级标题第四步：输入代码黑体部分

Microsoft Windows [版本 10.0.18363.1440]
© 2019 Microsoft Corporation。保留所有权利。

C:\WINDOWS\system32>net stop mysql
MySQL 服务正在停止…
MySQL 服务已成功停止。

C:\WINDOWS\system32>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

C:\WINDOWS\system32>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.49-community MySQL Community Server (GPL)

Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> insert into user(User,Password) values(‘root’,PASSWORD(‘123456’));
ERROR 1046 (3D000): No database selected
mysql> use mysql
Database changed
mysql> insert into user(User,Password) values(‘root’,PASSWORD(‘123456’));
ERROR 1364 (HY000): Field ‘ssl_cipher’ doesn’t have a default value
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

mysql> grant all privileges on mysql. to root@localhost identified by ‘123456’;*
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> grant reload on . to ‘root’@‘localhost’;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

六级标题删除skip-grant-tables，重启服务器

C:\WINDOWS\system32>net stop mysql
MySQL 服务正在停止…
MySQL 服务已成功停止。

C:\WINDOWS\system32>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。