Re: Cannot use caching_sha2_password using XDevAPI, unless using mysqlsh first

[Rui Quelhas]

Hi Geert,

I guess this more of a general X DevAPI question and can be asked in the X DevAPI forum (https://forums.mysql.com/list.php?176). 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