Yes I can connect using the mysql command line tool. No, the gnucash db has not been created.
But I cannot use the mysqlworkbench shell. It complains about a missing connector (python?) Also, gnc get the "bad data" error even if I try to "save as" with a bad password, no password, or no user id. So it doesn't look like it is really hitting the db at all. Keith On Wed, Mar 6, 2019 at 3:28 PM Colin Law <clan...@gmail.com> wrote: > On Wed, 6 Mar 2019 at 19:09, Keith Bellairs <ke...@bellairs.org> wrote: > > > > gnucash.trace is empty. > > > > Of some interest, I did a Save As to sqlite and it worked. So the xml > data is acceptable to that DB. > > > > XML -> sqlite OK > > XML -> mysql NG > > sqlite -> mysql NG > > > > I tried to do a Save As from the sqlite db to MySQL. That Save As ground > away for a few minutes and then threw the same bad data error. So I am > guessing that I have a problem with my mysql server. But of course the > error log for mysql is clean. > > > > There may be some mysql magic I am missing. Since I don't live there I > may not push on it much longer. > > Can you connect to the database using the command line utility with > that user/pwd you specified? > Has it created the database when you look from the command line? > > Colin > _______________________________________________ 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.
