Peter Morris
Reputation: 23224
MySql: Authentication method 'caching_sha2_password' failed
Trying to connect to MySql from .net started giving me the following error:
Authentication method 'caching_sha2_password' failed. Either use a secure connection, specify the server's RSA public key with ServerRSAPublicKeyFile, or set AllowPublicKeyRetrieval=True
Upvotes: 2
Views: 808
Answers (1)
Peter Morris
Reputation: 23224
For some weird reason, the solution is to sign into the server using MySql Workbench, and then the server will start accepting connections again.
Upvotes: 5
Related Questions
- php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
- How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio
- "Authentication plugin 'caching_sha2_password'
- Authentication method 'caching_sha2_password' not supported by any of the available plugins
- MySQL Authentication method error - Caching SHA-2
- caching sha2 password is not supported mysql
- "Authentication plugin 'caching_sha2_password' cannot be loaded. The specific module can not be found"
- caching_sha2_password mysql error
- MySQL Error: Authentication plugin 'caching_sha2_password' cannot be loaded
- MySQL changing authentication type from standard to caching_sha2_password