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

[Colin Law]

I expect that gnucash assumes you are using the default mysql port.

Colin

On Mon, 19 Nov 2018, 03:31 Peter Holck <pholck.basura at gmail.com 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 <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
>>
>