Metabase with Mysql 8.X

Hi.

How I can use Mysql 8.x with Metabase ?
The problem is in the connection : “com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.”

Mysql version:
mysql> SHOW VARIABLES LIKE “%version%”;
±-------------------------±------------------------------+
| Variable_name | Value |
±-------------------------±------------------------------+
| immediate_server_version | 999999 |
| innodb_version | 8.0.17 |
| original_server_version | 999999 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |
| version | 8.0.17 |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.2.11 |
±-------------------------±------------------------------+

Java Version:
openjdk version “1.8.0_252”
OpenJDK Runtime Environment (build 1.8.0_252-b09)
OpenJDK 64-Bit Server VM (build 25.252-b09, mixed mode)

Metabase version:
You’re running Metabase 0.23.1 which is the latest and greatest!

Thanks in advance !!!
Jaume.

Hi @Jaume_tis
You are not using the latest version, which is another issue, so upgrade to 0.35.4 - make sure to make backups before upgrading.
https://www.metabase.com/start/

When you have upgraded, you might see serverRsaPublicKeyFile not set, when trying to connect, but there’s several workarounds:
https://github.com/metabase/metabase/issues/12545