[GNC] Saving to MySQL

[Ira Fuchs]

(Found mysql in /usr/local/mysql/bin)
I can get to the mysql prompt but how to get Gnucash to be able to save?


> On Dec 10, 2020, at 9:16 AM, Peter West <lists at pbw.id.au <mailto:lists at pbw.id.au>> wrote:
> 
> The user id running the server is usually _mysql (note the underscore). I assume you specified root as the mysql users (given the URL you are using.)
> 
> Can you open a terminal (search terminal in spotlight)? Try typing
> mysql -u root
> 
> It should start mysql and ask for a password for root, provided you specified one.
> 
> Peter
> 
> --
> Peter West
> pbw at pbw.id.au <mailto:pbw at pbw.id.au>
> “Behold, I am the servant of the Lord; let it be to me according to your word.”
> 
>> On 10 Dec 2020, at 4:47 am, Ira Fuchs <irafuchs at gmail.com <mailto:irafuchs at gmail.com>> wrote:
>> 
>> I have installed MySQL 8.0.22 on a Mac running Mojave (v10.14.6) with no changes to any configuration file. I would like to save my GnuCash file to this server but I am getting an error:
>> 
>> The server at URL mysql://root@localhost/gnucash <mysql://root@localhost/gnucash> <mysql://root@localhost/gnucash <mysql://root@localhost/gnucash>> experienced an error or encountered bad or corrupt data.
>> 
>> What to do?
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <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.
>