Dear John, Thank you for your reply , I will try ubuntu 20.04 .
Thanks & Best Regards / Kerwin -----邮件原件----- 发件人: John Ralls <jra...@ceridwen.us> 发送时间: 2020年10月4日 23:45 收件人: xuhengx...@outlook.com 抄送: gnucash-user@gnucash.org 主题: Re: [GNC] win10/mysql/error > On Oct 3, 2020, at 1:30 AM, xuhengx...@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@01D699A1.5EF35CC0] > > > > [cid:image002.png@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
