Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution to the 1130 error in navicat, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article.

Navicat for MySQL 1130 error

Problem description:

1130-Host 'localhost' is not allowed to connect to this MySQL server

Cause analysis:

MySQL has only one root user. If you change your root password and select MD5, you will receive a Host 'localhost' is not allowed to connect to this MySQL server "error when you log in again after submission.

Solution:

Edit my.ini

Add a sentence to the paragraph of [mysqld]: skip-grant-tables

For example: Java code

[mysqld] datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockskip-name-resolveskip-grant-tables

In this way, the access control of MySQL can be skipped and anyone can enter the MySQL database as an administrator on the console.

It is important to note that after changing the password, the MySQL server will not take effect until it is stopped and restarted.

Modify through the method of rights management:

If you are using phpmyadmin, you can log in to phpmyadmin and enter in Rights Management. You will see all the users here, find the root user, click modify, and then change the domain to the "%" number. It is important to note that you must be logged in as a root user, otherwise it cannot be modified.

Thank you for reading this article carefully. I hope the article "the solution to 1130 errors in navicat" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.