Check credentials in MySQL. Specifically permissions for Root@Localhost On Sat, Nov 17, 2018 at 5:38 PM Colin Law <clan...@gmail.com> wrote:
> On Sat, 17 Nov 2018 at 22:31, Peter Holck <pholck.bas...@gmail.com> wrote: > > > > Thanks for your suggestion. No, with only my new instance of MySQL > running (8.13 running, 5.6 stopped) when I use the GnuCash API to create a > new shell database (shelldb) and try to save as mysql, I get the same > error: "The server at URL mysql://root@localhost/shelldb experienced an > error or encountered bad or corrupt data". It seems to me the GnuCash API > is looking for an instance of my old version of MySQL (5.6) and if it's not > running, then it fails. > > You haven't told us what you found when you looked in the trace file. > > Colin > > > > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law <clan...@gmail.com> wrote: > >> > >> Are you able to Save As mysql with the new server? > >> Also have a look in the trace file and see what it says, often it will > >> give more information in the case of db problems. > >> > >> Colin > >> On Sat, 17 Nov 2018 at 22:07, Peter Holck <pholck.bas...@gmail.com> > wrote: > >> > > >> > I recently installed an updated version of MySQL Server (8.13) on my > >> > machine. I have an established GnuCash database under an instance of > MySQL > >> > 5.6. I copied all GnCash db/tables from that older version of MySQL > to an > >> > identically named database/tables in MySQL 8.13. > >> > > >> > How do I get the GnuCash API to connect to my new instance of MySQL > (8.13) > >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 > running, > >> > and then attempt to start GnuCash it asks for username and password > (also > >> > identical for the two different MySQL versions) but then gives the > standard > >> > error that the server encountered bad or corrupt data. > >> > > >> > Thanks in advance. > >> > _______________________________________________ > >> > gnucash-user mailing list > >> > gnucash-user@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. > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. > _______________________________________________ gnucash-user mailing list gnucash-user@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.
