JDBC Driver for MySQL 8.X and SHA256

[Derek Jones]

Hello all, 

We have a small proof-of-concept data warehouse that is part of a consolidation project for employee records, pulling data from multiple systems, such as AD/Azure Entra and the HRIS system.  For the time being, the data warehouse is based on MySQL 8 and uses SHA256 for password encryption, which is new to us.  Attemping to use a JDBC data source OOB, the error is "Client does not support authentication protocol requested by server."  However, updating the testing MID to either MySQL Connector 9.3.0 or Maria  Java client 3.5.3 results in a "Client does not support authentication protocol requested by server. Consider upgrading MariaDB client. plugin was = sha256_password."  I'm sure we're not the only ones attempting this, but I haven't found much in my searching, as I was hoping for a little nudge in the right direction.  

Anyone already connected to a JDBC source using SHA256 that could offer a quick tip on getting the connection open?  

Thanks in advance for any help!

[Derek Jones · Accepted solution]

So, quick update—I got this working.  Using the post for establishing a connection to a SAP HANA data source, I figured out how to get this working on our MySQL database.  If anyone needs it, here's the post I used. If anyone wants it, I'll post the specifics on how I got MySQL working.