Docker MySQL 9 & Metabase

Get Help
1

Hi

I am trying to connect Metabase to MySQL 9 instance. The error below is returned

Could not connect to address=(host=172.19.0.17)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile)

The documentation mentioned to add

command: ["--default-authentication-plugin=mysql_native_password"]

to the docker yml file, which I did. However, the docker MySQL instance keep failing when adding the command. Upon further reading it seems that MySQL has completely dropped the native password plugin.

Is there another way to work around the issue or is downgrading going to be the only option?

2

Good opportunity to switch to Postgres?

3

Check

image
image1215×667 69.3 KB

4

the only way I see now is to use another database that uses your mysql as a source (e.g. clickhouse, athena, bigquery), but from the metabase side there's no way since we "might" (please don't take this for granted) to make a new driver for mysql

5

Thanks for all the replies.

I'll spin up a MySQL 8 docker instance for now and enable the native password plugin.