[GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Peter Holck]

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 <clanlaw at gmail.com> wrote:

> On Sat, 17 Nov 2018 at 22:52, Peter Holck <pholck.basura at 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
>