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

[Geert Vanderkelen]

It was obvious that I made mistakes in my code, but I had a hard time finding out what. Especially that when the cache was warmed up through another channel, it all seemed to work.

The two mistakes was that
1. I forgot the '*' when encoding the authentication data for MYSQL41.
2. In the PLAIN encoding, and this is something I should have seen quicker and bang my hand for it: I used %x instead of %s when formatting the authentication data. So, I was sending the incorrect password.. as hex..

BTW, I know documentation is hard to maintain, but the X Plugin ain't easy to grasp. The best way is to look at existing connectors, and, oddly enough Connector/Net helped me the most :) (If you know me, that is indeed strange!)