MySQL reports an error: errorcode 1130, state HY000
Scenario: the following error is reported during springboot startup:
The XML configuration is as follows:
It can be started normally when writing 127.0.0.1 or localhost. After rewriting 192.168. X.x, an Error 1130 is reported.
Reason: MySQL does not have this permission
Solution:
-
- switch to the MySQL installation directory and execute: MySQL – U root – P enter the password
-
- execute the command to authorize the user: grant all privileges on. To ‘root’ @ ‘%’ identified by ‘root’; (%) It means that after all ip
-
- execute the above commands, refresh the permissions with the following command: flush privileges
- restart MySQL service
Read More:
- Mysql 8.0.13 Enabling remote access (ERROR 1064 (42000): You have an error in your SQL syntax; check the manual th)
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] mysql 2003 remote access failed mysql8 configure remote access
- [Solved] MYSQL Error: unknown error 1130, unknown error 1045
- [Solved] Navicat connection error 1251 compatibility with docker MySQL
- Docker mysql8 modify password
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- MySQL Change password failure prompt: ERROR 1064(42000):You have an error in your SQL syntax: check the corresponds to your M
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;
- MySQL (version 8.0) connection error: 1251 [How to Solve]
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin