[GNC] Saving to MySQL

[Peter West]

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
“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> 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> experienced an error or encountered bad or corrupt data.
> 
> What to do?
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.