I am using a remote connection to the MySQL server database today. No matter how it is connected, the error code is 1130, error 1130: Host 192.168.2.159 is not allowed to connect to this MySQL Server
It is assumed that the remote connection User Permissions cannot be granted. As a result, the MySQL database can be operated.
After logging on to MySQL with IP address 127.0.0.1, change the "host" entry in the "user" table in the "MySQL" database to "%" from "localhost '..
Mysql-u root-P
Mysql> use MySQL;
Mysql> select 'host' from user where user = 'root ';
Mysql> Update user set host = '%' where user = 'root ';
Mysql> flush privileges;
Mysql> select 'host' from user where user = 'root ';
The first sentence is to authorize the User Root to log on.
Second sentence: Select MySQL database
Third sentence: view the host value of the User table in the MySQL database (the host/IP name that can be accessed through connection)
Fourth sentence: Modify the host value (add host/IP address with the wildcard % content), of course, you can also directly add IP addresses
Fifth sentence: refresh the MySQL system permission table
The sixth statement is modified when you re-view the user table ..
Restart the MySQL service.
======================================
1. This error occurs when you connect to MySQL through mysql-front or MySQL administrator.
Error 1130: Host ***. *** is not allowed to connect to this MySQL Server
This indicates that the connected user account does not have the permission for remote connection and can only log on to the Local Machine (localhost.
You need to change the host entry in the User table of the MySQL database.
Rename localhost as %
First, log on to the MySQL server by following the steps below
To log on to MySQL, you need to switch to the bin directory of MySQL under DOS and perform the following operations:
Syntax format: mysql-H host_name-u user_name-P password (Local-H and host_name can be saved)
For example:
C: \ Program Files \ mysql \ MySQL Server 5.0 \ bin> mysql-u root-P
Enter Password :******
Enter the username and password (-P), press enter, and then "Enter Password:". Then enter the password and press Enter.
Log on to MySQL. Otherwise, the logon fails.
After successful login, the following information and MySQL identifier are displayed:
Welcome to the MySQL monitor. commands end with; or \ G.
Your MySQL connection ID is 1 to server version: 5.0.1-NT
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql>