Thanks again for your help; I think I understand my problem now. GnuCash (reasonably) looks for an instance of MySQL using the same port that it used when closed (or when created? Not sure). Anyway, I had assigned a different port number to my new version of MySQL (since I wanted to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until I confirmed the new version was working correctly). Swapping the port numbers so the new 8.0 version used the old 5.6 port and vice versa (via editing the my.ini config file) seems to have done the trick.
Thanks! On Sun, Nov 18, 2018 at 1:21 AM Colin Law <clan...@gmail.com> wrote: > On Sat, 17 Nov 2018 at 22:52, Peter Holck <pholck.bas...@gmail.com> wrote: > > > > * 15:25:47 CRIT <gnc.backend.dbi> > [GncDbiBackend<Type>::session_begin()] Unable to connect to database > 'gnucash' > > Please copy the list on replies, you sent this one just to me. On > gmail use Reply All when replying. > > Are you able to connect to the server using the command line client > mysql -u username -p > and it will prompt for the password. > > If that connects then > show databases; > will show the databases (oddly enough). Then you can exit with > exit; > > 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.
