Connection error with MySQL 8 server
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 Answered by Andrew B in this comment.
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.