[GNC] win10/mysql/error
John Ralls
jralls at ceridwen.us
Sun Oct 4 11:44:52 EDT 2020
> On Oct 3, 2020, at 1:30 AM, xuhengxiao at outlook.com wrote:
>
> Dear Sir/Medam ,
>
>
>
> I change my computer ,
>
> Win10 2004
>
>
>
> Gnucash : the last
>
> Version: 4.2
>
> Build ID: 4.2+(2020-09-26)
>
> Finance::Quote: -
>
>
>
> Mysql : the last mysql Ver 8.0.21 for Win64 on x86_64 (MySQL Community Server - GPL)
>
> [cid:image001.png at 01D699A1.5EF35CC0]
>
>
>
> [cid:image002.png at 01D699A2.59C06120]
>
> Thanks & Best Regards / kerwin
> <image001.png><image002.png>
This came up on IRC last Thursday: https://code.gnucash.org/logs/2020/10/01.html#T17:45:55
The problem seems to be that MySQL 8 has implmented a new authentication scheme with SHA2. GnuCash on Windows uses MariaDB instead of MySQL because MySQL also dropped their C-based client in favor of a C++ one and the C++ one doesn't integrate with libdbi. MariaDB doesn't implement the SHA2 based authentication. The answer to https://stackoverflow.com/questions/51567604/rmariadb-caching-sha2-password-error-when-connecting-to-mysql offers a workaround.
Regards,
John Ralls
More information about the gnucash-user
mailing list