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

[Peter Holck]

I recently installed an updated version of MySQL Server (8.13) on my
machine. I have an established GnuCash database under an instance of MySQL
5.6. I copied all GnCash db/tables from that older version of MySQL to an
identically named database/tables in MySQL 8.13.

How do I get the GnuCash API to connect to my new instance of MySQL (8.13)
? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running,
and then attempt to start GnuCash it asks for username and password (also
identical for the two different MySQL versions) but then gives the standard
error that the server encountered bad or corrupt data.

Thanks in advance.