[GNC] Gnucash 3.8 Flatpak Not Connecting to MySQL

[Alan Whiteman]

Hello,

Recently I moved to KDE Neon as my preferred distro, I had manually 
installed Gnucash 2.6 which connected to MySQL perfectly fine. A recent 
system update forced the removal of Gnucash in order to update some 
libraries. When I tried to re-install from the Discover Software Center, 
the only version available was 3.8 via Flatpak.

The installation of this version went fine, with some minor changes:

"Your gnucash metadata has been migrated.

Old location: /home/user/.gnucash
New location: /home/user/.var/app.org.gnucash.GnuCash/data/gnucash

If you no longer intend to run GnuCash 2.6.x or older on this system you 
can safely remove the old directory.

In addition:

The following file has been copied to 
/home/alan/.var/app/org.gnucash.GnuCash/config/gnucash instead:
-config.user (Renamed to: config-user.csm)"


But when I try to retrieve my old accounts, it refuses to connect to the 
database, with the following message:

"The server at URL mysql://user@localhost/gnucash experienced an error 
or encountered bad or corrupt data."

In the end, I uninstalled Gnucash 3.8 Flatpak version and installed 
2.6.19 through apt, which works.

Any insights into making the newer version work will be greatly appreciated.