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 <[email protected]> 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 > [email protected] www.ihtfp.com > Computer and Internet Security Consultant > _______________________________________________ gnucash-user mailing list [email protected] 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.
