[Bug]: cannot use a mySQL database source, error message ''Error: Driver not loaded Driver not loaded"

[ndpegram]

JASP Version

0.19.0

Commit ID

No response

JASP Module

Unrelated

What analysis are you seeing the problem on?

none

What OS are you seeing the problem on?

Flatpak

Bug Description

Similar to the PostgreSQL issues listed in bugs #2199 and #2209, I cannot connect to a mySQL database.

I was testing, having never used database connections to jasp, so set up access on my local server, with a dedicated username and password, granting access only from my desktop's IP address. When clicking on the "Connect to database" button, the error reported in the other two reports is returned.

(Note that the hostname was correct when tested ("192.168.2.42").

I can connect to mySQL using the CLI interface using these credentials on the specified desktop.

Expected Behaviour

Database connection should be attempted.

Steps to Reproduce

1. Setup mySQL with database table with user having access permissions for the desired schema.
2. Enter details in database connection window
3. Click on "Connect to database" button.

Log (if any)

No mySQL log entries generated.

More Debug Information

No response

Final Checklist

• I have included a screenshot showcasing the issue, if possible.
• I have included a JASP file (zipped) or data file that causes the crash/bug, if applicable.
• I have accurately described the bug, and steps to reproduce it.

[JorisGoosen]

Is mysqlclient installed?

[hoggatt]

I installed VIA the Microsoft Store on Windows and am getting the same behavior. Installing the ODBC and C++ MySQL Connectors from here didn't help.

[ndpegram]

Is mysqlclient installed?

Yes, as noted in the original post, I can connect via the CLI.