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

[Geert Vanderkelen]

Hi Rui,

Thanks for your help. And indeed, I posted to the wrong forum. I think 'document store' scared me off :)

Yes, I do what you describe. PLAIN is used while using TLS, and looping over MYSQL41 and SHA256_MEMORY.

However, though PLAIN works, I can never use SHA256_MEMORY (user has authentication plugin set to 'caching_sha2_password'), whether TLS or not TLS.

But when I first use 'mysqlsh' with that user, and then use my code: all works as expected, that is, I can use SHA256_MEMORY over no-TLS connection.

I am actually checking the X Plugin source in the mysql-server source to see when it gets cached.

Maybe I'll find out why, and if not, revive the discussion in the other forum.

Cheers,
Geert