MySQL – Connectivity – Error – “Unable to load authentication plugin ‘caching_sha2_password’. “

Background

Another error encountered while trying to connect to a MySQL instance.

Error

Error Text

Unable to load authentication plugin ‘caching_sha2_password’.

Error Image

Unabletoloadauthenticationplugincaching_sha2_password.01.20200804.0707AM

Troubleshooting

Outline

  1. Review Installation Configuration Options
    • Options
      • Authentication Method
        • Use Strong Password Encryption for Authentication
          • Our Choice
        • Use Legacy Authentication Method
  2. Review Available MySQL Driver Versions
    • Generic
      • Review the versions of MySQL Client Drivers that are accessible
    • DBeaver
      • Our version of DBeaver is v5.0.4
      • Please access “Driver Manager” to track available Drivers for MySQL
      • In our case availed MySQL Drivers are:-
        • MySQL
        • MySQL 3.x

Installation Configuration Options

Images

Image – Installation – Authentication Method

installation.authenticationMethod.01.20200805.0844AM.PNG

 

MySQL Driver Options

Images

Image – Driver Manager

dbeaver.driverManager.v5_0_4.01.20200804.0718AM

Remediation

Outline

  1. Upgrade your client to the most recent version
  2. Client:- DBeaver
    • In our case we upgraded our client from v5.0.4 to v7.1.4

Images

Image – Database – Driver Connection

Image – DBeaver – v5.0.4

Image – Dbeaver – v5.0.4 – Connection Type

newConnection.01.MySQL.ConnectionType.01.20200804.0757AM

Image – Dbeaver – v5.0.4 – Connection Settings – Tab – General

newConnection.01.MySQL.ConnectionSettings.01.Tab.General.PNG

Image – DBeaver – v7

Image – Dbeaver – Connect to Database
Image – Dbeaver – Connect to Database – Select your database

selectYourDatabase.02.20200804.0818AM

Image – Dbeaver – Connect to database – Connection Settings – Tab – Main

ConnectionStrings.Tab.General.01.20200804.0810AM

Notable Mention

You already know who I roll with.

The Sergeant, Serge Rider, and the mean crew @ DBeaver.

Summary

In summary, please upgrade your MySQL Client application.

In our case, we upgraded DBeaver to latest version; currently at 7.1.14.

The latest version capably supports MySQL version 8.

References

  1. DBeaver
    • DBeaver – Issues
      • mysql: unable to load authentication plugin ”. #1042
        Link

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s