Menu
▾
▴
#241 mysql caching_sha2_password
closed
Bug Report
2020-09-29
2018-04-26
No
MySQL 8 introduces the caching_sha2_password, I have tried setting MYSQL_OPT_GET_SERVER_PUBLIC_KEY option along with using the most recent libmysql.dll without much luck.
Is MYSQL_OPT_GET_SERVER_PUBLIC_KEY supported?
https://dev.mysql.com/doc/refman/8.0/en/mysql-options.html
This is not supported currently. Implementing it would require a modification of TMySqlOption in ZPlainMySqlConstants.pas as well as a modification of TZMySQLConnection.Open in ZDbcMySql.pas.
I have modified the above files, thanks for the tip. Still no success.
Only real example I have found
https://insidemysql.com/preparing-your-community-connector-for-mysql-8-part-1-sha256/
I'll keep trying, but details attached for anyone else interested.
The issue is so far there is no version 8 libmysql.dll. The only version on the site is still 6; a version of 8 x64 is bundled with the server, not x86. So a 64bit binary works.
Hmmm - that is sad to see. I would like to integrate your changes into the Zeos 7.3 codebase nonetheless, if you think it works. Is the MYSQL_OPT_GET_SERVER_PUBLIC_KEY .zip still valid for that or did you do other changes?
Those changes are all I made, I also added some of the other New options
Hi, i've ported all new MySQL8 options. You had a bug in your patch (the Ordinal value of MYSQL_OPT_GET_SERVER_PUBLIC_KEY was wrong because of wrong enum order).
Patch done R6125 /testing-7.3 (SVN)
Please close if OK
No reply, reopen if not OK.
Regards, Michael