[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