When connecting to a remote MySQL database, "Navicat for mysql 1130 error" sometimes appears, indicating that the connection to the MySQL service is not allowed. Many people think that the firewall is causing trouble. In fact, turning off the firewall still cannot solve the problem. This tutorial will introduce how to solve the Navicat for MySQL 1130 error.
Recommended tutorial: MySQL introductory video tutorial
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. After changing the root password, I selected MD5. After submitting and logging in again, Host 'localhost' is not will appear. allowed to connect to this MySQL server" error message.
Solution:
Edit my.ini
In [ mysqld] add a sentence: skip-grant-tables
For example: Java code
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-name-resolve skip-grant-tables
This way you can skip MySQL access control and anyone can manage it on the console Enter the MySQL database as a user.
It should be noted that after changing the password, you must stop and restart the MySQL server for it to take effect.
Pass permissions Management method modification:
If you are using phpmyadmin, you can log in to phpmyadmin, and then enter in permission management. You will see all users here. Find the root user and click Modify, then Just change the domain to "%". It should be noted that you must be logged in as a root user, otherwise it cannot be modified.
The above is the detailed content of How to deal with 1130 in navicat. For more information, please follow other related articles on the PHP Chinese website!