DBeaver cannot verify the MySQL server certificate
unable to find valid certification path to requested targetShort answer
DBeaver's MySQL driver is checking the server certificate and Java does not trust the CA that signed it. Import the server's CA file into a truststore with keytool and give DBeaver that truststore through driver properties, or set the CA certificate in the SSL tab. Turning verification down is only for trusted networks.
Fix it fast
1Find out which cause you have
Find out who signed the server certificate, because the CA file is what the driver is missing. Ask the server for the CA file path it uses.
mysql -u root -p -e "SHOW VARIABLES LIKE 'ssl_ca'"2Match what you see, then jump to its fix
- 1
The error appears only with SSL verification on (VERIFY_CA or VERIFY_IDENTITY); the server uses a self-made or private CAThe CA that signed the server certificate is not in Java's truststoreFix - 2
SSL is enabled for the connection but no CA Certificate path is filled inThe CA certificate is not set in DBeaver's SSL tabFix
- 1
What does the error look like?
unable to find valid certification path to requested target
Cause 1 of 2
The CA that signed the server certificate is not in Java's truststore
1Check
With verification on, Java checks the server certificate against its default trusted CAs, usually $JAVA_HOME/lib/security/cacerts. A private CA is not there.
keytool -list -keystore $JAVA_HOME/lib/security/cacerts | grep -i mysql2Fix
Import the CA file (ca.pem from the server) into your own truststore, then tell the driver about it. In DBeaver open the connection, Driver properties, and add the two Connector/J properties below.
keytool -importcert -alias MySQLCACert -file ca.pem -keystore truststore -storepass mypassword
# DBeaver > Edit Connection > Driver properties
trustCertificateKeyStoreUrl = file:/path/to/truststore
trustCertificateKeyStorePassword = mypassword3Verify
Press Test Connection in the DBeaver connection dialog.
keytool -list -keystore truststore -storepass mypasswordConfirmed by dev.mysql.com
Cause 2 of 2
The CA certificate is not set in DBeaver's SSL tab
1Check
Open the connection, add the SSL tab with the plus button, and look at the CA Certificate field and the Verify server certificate box.
ls -l /path/to/ca.pem2Fix
Set CA Certificate to the path of the CA file, keep Verify server certificate on, and use Test Configuration.
DBeaver: Edit Connection > SSL > CA Certificate = /path/to/ca.pem3Verify
Test Configuration reports success.
DBeaver: Test ConfigurationConfirmed by github.com
How do I stop it coming back?
- Keep the CA file with your connection documentation so a new laptop can import it in a minute.
- Do not turn certificate checks off for a server on the public internet.
- Use VERIFY_IDENTITY only when the host name in DBeaver matches the certificate.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Every cause above names the document that confirms it. I have not reproduced this fix on a machine of my own yet, so read it as documented guidance, not a test report. Found a mistake? Tell me.
Which stack is behind this page?
Projects of mine built on the same technologies:
- TaxiDexMy own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.
- QistLockA NestJS and React SaaS driving an Android Device Owner agent that locks financed phones when payments lapse.
- ShopGoAn e-commerce aggregator with a Python scraping engine behind its catalog, past 10K Google Play downloads.
Related fixes
Databases
Installing the Airflow MySQL provider fails on pkg-config or mysqlclient
Building the mysqlclient wheel fails during the install
The Airflow MySQL provider depends on mysqlclient, which pip compiles against the MySQL C client library.
2 causes, each with a fixDatabases
A query on Aurora MySQL dies with 'table /rdsdbdata/tmp/#sql... is full'
ERROR 1114 (HY000): The table '/rdsdbdata/tmp/#sqlfd_1586_2' is full
In Aurora MySQL 3, internal temporary tables share one pool, and when that pool and the memory-mapped overflow file are used up, a reader instance ends the query with error 1114.
3 causes, each with a fixDatabases
Azure Database for MySQL refuses a connection that does not use SSL
ERROR 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.
Azure Database for MySQL Flexible Server requires encrypted connections by default (require_secure_transport = ON, TLS 1.2).
4 causes, each with a fixDatabases
Compiling a C or C++ program that includes mysql.h fails
undefined reference to `mysql_init'
The compiler only finds mysql.h when the MySQL client development files are installed and their folder is on the include path.
3 causes, each with a fixDatabases
DBeaver fails to resolve Maven dependencies when downloading a database driver
A driver library does not download automatically
DBeaver downloads driver jars from a Maven repository.
3 causes, each with a fixDatabases
Django cannot load MySQLdb and asks whether mysqlclient is installed
Error loading MySQLdb module: Did you install mysqlclient or MySQL-python?
Django's MySQL backend imports MySQLdb, which is provided by the mysqlclient package.
3 causes, each with a fix