The Ultimate Guide to High Availability with MariaDB

Connection error with MySQL 8 server

You are viewing an old version of this question. View the current version here.

I've been trying to move off the MySQL driver to the MariaDB. It works fine with MySQL 5.7. It works fine when I run MySQL 8 with --default-authentication-plugin=mysql_native_password. I've tried multiple versions of MariaDB Connector/J, and each one gives the same error. According to the documentation, this shouldn't be an issue.

Client does not support authentication protocol requested by server. plugin type was = 'caching_sha2_password'

For what it's worth, I'm using MySQL 8.0.32 in a docker container and my app is currently using MariaDB Connector/J 2.7.12 on Scala 2.12. My laptop is using MacOSX Ventura 13 and it uses an M1 chip.

Any help would be appreciated.

Answer

This was not a bug in the driver. It was caused by merge conflicts in the sbt build.

I discovered the real problem when "sbr run" worked as expected. This led me to try building without the merge logic and manually exclsing the conflicting jar files.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.