ERROR1130 (HY000): Host 'localhost' solution _ MySQL

ERROR1130 (HY000): Host bitsCN.com

ERROR 1130 (HY000): Host 'localhost' solution

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

Cause:

Mysql only has one root user. after changing the root password, select MD5. after submission, click

"Host 'localhost' is not allowed to connect to this MySQL server ..."

Try the user table in another mysql database and overwrite it. no, it is estimated that the version is different.

Solution:

Edit my. ini

In the [mysqld] section, add skip-grant-tables.

For example:

Java code

[Mysqld]

Datadir =/var/lib/mysql

Socket =/var/lib/mysql. sock

Skip-name-resolve

Skip-grant-tables

The purpose is:

Skip MySQL access control. anyone can enter the MySQL database as an administrator on the console.

It should be noted that after the password is changed, the MySQL server should be stopped and restarted to take effect.

Restart the mysql service!

BitsCN.com