This bug was initially created as a copy of Bug #1849812
I am copying this bug because:
mariadb-java-client was updated to 2.7.1 in RHEL-7, so we have a regression in RHEL-8 now. We should figure out how to close this gap (whether the rebase would be acceptable in RHEL-8 or whether to include a new package).
Description of the original problem (RHEL-7):
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):
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).
App fails to connect to the database.
A successful connection must happen.
Workaround is to switch back to the old authentication plugin: mysql_native_password
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 (mariadb-java-client bug fix and enhancement update), and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.