Description of problem: Would be good if the mariadb-java-client distributed on rhel is greater than version 2.5, on this version support to the 'caching_sha2_password' on the client side, the current version does not support it thus we need to configure the MySQL or Mariadb newer versions to use the old authentication plugin: mysql_native_password Version-Release number of selected component (if applicable): mariadb-java-client: 2.2.5 How reproducible: Use this driver to connect to a MySQL 8 database. Steps to Reproduce: Try to connect an application to the MySQL 8 database with the caching_sha2_password authentication plugin enabled (defualt). Actual results: App fails to connect to the database. Expected results: A successful connection must happen. Additional info: Workaround is to switch back to the old authentication plugin: mysql_native_password
Hi @hhorak, sry for the delay, and thanks for your reply. At this point, I think we can wait the normal release flow. I thought there would be customer asking for it, but so far we haven't. For people that are hitting the issue related with the security we are suggesting to use that workaround.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (new packages: rh-mariadb105), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHEA-2021:2217