Connector/Net connectivity issue when sha256_password is set to default
Posted by: Muhammad Naveed
Date: February 16, 2017 06:11AM


We have a MySQL server where sha256_password plugin is enabled and set to default. Now when we try to connect it using Connector/Net it shows following error,

Authentication to host 'xxxxxx' for user 'sha256_user' using method 'sha256_password' failed with message: Bad handshake

Note that his error is shown for all connections even if I try to use a user with native password as well.

Now if we made the native password plugin as default in MySQL, and then try to connect with the server, it works for the SHA-256 users as well with same SSL certificate and settings. However, when we made the sha256 plugin default again, it starts showing the same handshake error again.

I have tried also specifying the client certificate file (PFX) with the connection string but still same error. When we use the same client files (pex) with python or PHP, it works. For PHP and Python it works even if we have sha256_password set to default on MySql.

Can anyone please suggest if any other settings is required at connector/net when sha256 is set to default?


Options: ReplyQuote

Written By
Connector/Net connectivity issue when sha256_password is set to default
February 16, 2017 06:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.