Hi,
I am trying to connect to a MySQL server 8.4, from a Windows11 PC. Prior to that server being upgraded (version5 I believe it was to be), I was able to connect successfully: LIBNAME MYSQLDB2 MYSQL USER=xxxxxx PASSWORD=yyyyyy SERVER=123.456.789 DATABASE=database1;
Since I was not able to connect I went searching for possible solutions and found that an article informing that "sha256_password" authentication was deprecated (newer MySQL versions)
"sha256_password (deprecated): Implements basic SHA-256 authentication".
The SAS error reads: "ERROR: A database error occurred. The database specific error follows: DB: MYSQL: Connecting : Database error message is as follows:
2059 SQLSTATE(HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found."
Anyone encountered this type of a problem, and was able to solve this as well? It seems like newer MySQL versions (>=8.4) are mostly involved. (note that I am not that familiar with such connectivity matters).
Regards,
KC
