There has been this bug in the past two days. Record the solution and summary.
Solution:
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:
Download address
We can find out the reason according to the actual situation.
Read More:
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- pymysql Error: File “/usr/local/lib/python2.7/site-packages/PyMySQL-1.0.2-py2.7.egg/pymysql/connections.py”, line 167 SyntaxError: invalid syntax
- postgresql-Database query problem-ERROR: column “t.domainid“ must appear in the GROUP BY clause or be used in an a
- [Solved] C# connecting to MySQL database reports an error
- scm_prepare_database.sh CDH initial data script execute error
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- [How to Fix] Database can’t open file (errno:24)
- ERROR 1075 (42000) Incorrect table definition; there can be only one auto column and it must be defi
- [Solved] public key is not available client side (option serverRsaPublicKeyFile not set)
- [Solved] Red hat 7.9 install DM8 of Damon database and starting graphical error with xmanager enterprise 5
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- Oracle Database AWR error: ORA-06502 [How to Solve]
- Oracle11g Startup Database Error: ORA-27154: post/wait create failed