mySQL unable to load plugin

[Russell Castagnaro]

Hello!
I'm trying to set up the database connection for ART and getting the following error:

Unable to load authentication plugin 'caching_sha2_password'

art.artdatabase.ArtDatabaseController - Error
java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:868)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:864)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1746)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</init></init>

[Timothy Anyona]

Hello,
This seems to be related to the use of MySQL 8+. One of the solutions seems to be to alter the mysql user and specify the authentication mechanism. Another solution would be to download and use the MySQL 8 JDBC driver and use the appropriate classname.

https://stackoverflow.com/questions/50387952/how-to-resolve-unable-to-load-authentication-plugin-caching-sha2-password-issu
https://medium.com/@orafaelreis/workaround-to-unable-to-load-authentication-plugin-caching-sha2-password-message-85ddf6a98611
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-api-changes.html

[Russell Castagnaro]

This worked perfectly, Thank You

[Timothy Anyona]

You're welcome.

[Timothy Anyona]

ART 5.6 now comes with the MySQL 8 driver.