You can set a port number when saving to DB. If not set, GnuCash will use the default. There is no separate field for it, but I believe you can use a "host:port" format in the hostname field.
If you prefer to keep the non-default port number for your mysql server, you can reopen your db in gnucash using File->Open and set the proper db hostname and port. GnuCash should remember your settings for the next time. Geert Op maandag 19 november 2018 08:32:33 CET schreef Colin Law: > I expect that gnucash assumes you are using the default mysql port. > > Colin > > On Mon, 19 Nov 2018, 03:31 Peter Holck <[email protected] wrote: > > 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 <[email protected]> wrote: > >> On Sat, 17 Nov 2018 at 22:52, Peter Holck <[email protected]> > >> > >> 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 > [email protected] > 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 [email protected] 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.
