MySQL Forums
Forum List  »  Connector/Node.js

Re: Cannot use caching_sha2_password using XDevAPI, unless using mysqlsh first
Posted by: Geert Vanderkelen
Date: March 18, 2022 03:13AM

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!)

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.