ERROR 1130 (HY000): Host 'localhost' solution ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server www.2cto.com cause: mysql only has one root user. After the root password is changed, MD5 is selected. After the request is submitted, the "Host 'localhost' is not allowed to connect to this MySQL server... "Try to overwrite the user table in another mysql database. It is estimated that the version is different. Solution: edit my. in the [mysqld] section of ini, add the following sentence: skip-grant-tables. For example: java code [mysqld] datadir =/var/lib/mysql socket =/var/lib/mysql/m Ysql. sock skip-name-resolve skip-grant-tables aims to: 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 and restart the mysql service!