[GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Adrien Monteleone]

As John mentioned, the db name seems incorrect. Did you register the db 
on MacOS?

Error 2026 deals with SSL certificate issues.

A web search should provide some guidance.

Maybe try without SSL to see if that resolves it? Then you can 
troubleshoot the SSL problem.

-----
And again, why do you think you need MySQL? What are you trying to 
accomplish?

Regards,
Adrien

On 3/16/22 10:40 PM, Neko Chang wrote:
> Thank you for the clarification.
> 
> Hi Adrien
> I am using MySQL @ FreeBSD remote mainly,
> MySQL @ MACOS for the issue tested.
> GNUCASH @ MACOS work fine both MySQL v8.0.23.
> 
> Hi Josh
> Either MySQL v8.0.23 or v8.0.28, all parameter
> same(user/password/database name).
> Therefore issue caused from libdbi I guess.
> 
> The issue would not be resolve.
> I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue.
> 
> Regards
> Neko
> 
> john <jralls at ceridwen.us> 於 2022年3月17日 週四 上午11:13寫道：
>>
>> Neko,
>>
>> AFAiCT this has nothing to do with macOS but rather that your MySQL server doesn't recognize the database name you passed it plus another error, number 2026, that GnuCash doesn't know how to handle.
>>
>> As a reminder, users using the MySQL or Postgresql backends *must* be *expert* database administrators for the respective servers. The GnuCash team most emphatically are not and cannot provide any support for database server problems. If you are not a MySQL expert then you should use the SQLite3 or XML backends which don't require DB Admin skills.