Re: Connection phase of mysql protocol, plugin authentication
Posted by: Filipe Silva
Date: January 06, 2021 05:17AM

Hi Dorothy,

You probably are missing a part of the caching_sha2_password implementation. FYI, caching_sha2_password is composed by two parts:

1. Full Authentication
This is similar to sha256_password, with a few differences in the exchanged messages (for example: request_server_public_key is 2 instead of 1)

2. Fast Authentication
First attempt to authenticate is done using a special hash key, falling back to full authentication in case of failure.

WL#9591 has some details about this. Please check it out and see if it helps you moving forward.

Options: ReplyQuote


Subject
Written By
Posted
Re: Connection phase of mysql protocol, plugin authentication
January 06, 2021 05:17AM


Sorry, only registered users may post in this forum.

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.