[GNC] Saving to MySQL

[Ira Fuchs]

Problem resolved. I was able to login to mysql using the mysql command but was not able to login using dbeaver. dbeaver gave an error message about sha2_caching_password. To fix that, I reinstalled mysql and specified legacy authentication. With that change dbeaver was able to connect and Gnucash is able to save to MySQL Perhaps there is a way to do this without reinstalling MySql (I tried creating a .cnf file to load the native password plugin but when I went to alter user root to use that, the command failed).

Thanks for your help.

> On Dec 10, 2020, at 9:51 AM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> Hi,
> 
> On Thu, December 10, 2020 9:27 am, Ira Fuchs wrote:
>> (Found mysql in /usr/local/mysql/bin)
>> I can get to the mysql prompt but how to get Gnucash to be able to save?
>> 
> 
> Is the server running?
> Can you actually get to the server via the command-line?
> What do you get from "show databases;" from the command-line prompt?
> 
> IF you can connect and "show databases" works, then you just need to give
> GnuCash the same connection information.   Oh, and you need to have all
> permissions to create the gnucash database.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
>