[GNC] 回复: win10/mysql/error

[徐 恒晓]

Dear John,

Thank you for your reply , I will try ubuntu 20.04 .

Thanks & Best Regards / Kerwin

-----邮件原件-----
发件人: John Ralls <jralls at ceridwen.us> 
发送时间: 2020年10月4日 23:45
收件人: xuhengxiao at outlook.com
抄送: gnucash-user at gnucash.org
主题: Re: [GNC] win10/mysql/error



> 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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcode.gnucash.org%2Flogs%2F2020%2F10%2F01.html%23T17%3A45%3A55&data=02%7C01%7C%7Cd2dc80520cb949ad369608d8687c7117%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637374230983203616&sdata=Bf8Hb%2F0gZuBbym0JK6IC4H2PxANhPYGOhCI6lh%2Bxg%2FM%3D&reserved=0

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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F51567604%2Frmariadb-caching-sha2-password-error-when-connecting-to-mysql&data=02%7C01%7C%7Cd2dc80520cb949ad369608d8687c7117%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637374230983203616&sdata=rZLPj5MW7zHMk6TyHB8iBSPs2XA3Ji%2BlxurPqMpaj9k%3D&reserved=0 offers a workaround.

Regards,
John Ralls