Attempting to Connect to MySQL 8.0.4 or Later Fails: Authentication Plugin caching_sha2_password is not Supported
Last updated on JULY 03, 2018
Applies to:MySQL Utilities - Version 1.5.2 and later
MySQL Server - Version 8.0 and later
MySQL Cluster - Version 7.6 and later
MySQL Connectors - Version 1.0 to 2.1 [Release 1.0 to 2.1]
MySQL Connectors - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.
After upgrading to MySQL Server 8.0.4 or after installing it, attempts to connect fails with an error saying that the caching_sha2_password plugin is not supported or similar.
The exact error message depends on which library/connector is used for the connection. Examples are:
- Connector/J 5.1.45:
MySQL Server 8.0.4 or later has been installed or an existing MySQL instance have been upgraded.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms