How to deal with 1130 in navicat

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!