MySQL Forums
Forum List  »  Connector/Node.js

Re: Cannot use caching_sha2_password using XDevAPI, unless using mysqlsh first
Posted by: Rui Quelhas
Date: March 16, 2022 04:21AM

Hi Geert,

I guess this more of a general X DevAPI question and can be asked in the X DevAPI forum ( However, I'll try to shed some light on the subject,

Given that you are enabling TLS, the X Plugin expects the password to be sent as plain-text, which means you need to use the "PLAIN" method. The same behavior is expected for connections using local Unix sockets.

You should loop over MYSQL41 and SHA256_MEMORY only for the case where the connection is not using TLS and is not over a local Unix socket.

Of course, I'm assuming that, in this case, the user is not setting a specific authentication method, because in that case, you should always try with the selected one.

Hope it helps

Options: ReplyQuote

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.