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:
- [Solved] Sqlyog always reports an error when creating a new connection.
- 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
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- Docker mysql8 modify password
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
- 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 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- 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