There has been this bug in the past two days. Record the solution and summary.
1. Driver configuration error (my bug)
2. Database connection address error
3. Account password error
4. The database is not started or has no right to access, such as without networking
5. The version does not correspond to (my bug)
6. Driver jar package is not introduced into the project
My MySQL jar package is 5.0.8, but my MySQL server is 8.0, so I can change it to 5.1.46!
Mysql-connector-java-5.1.46-bin.jar download address:
We can find out the reason according to the actual situation.
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- Ubuntu ODBC MySQL 8 OPTION NOT Work [How to Solve]
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- [Solved] SQLSTATE[HY000]  Connection refused to report an error when PHP connects to mysql in the docker container
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- Mysql18.104.22.168 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
- Python calls the MySQLdb library, and an error “Library not loaded: libmysqlclient.18.dylib” is reported
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- [Solved] MySQL Error: Client does not support authentication protocol requested by server
- [Solved] docker mysql SQLSTATE[HY000]  Connection refused
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;