Qlik MySQL Enterprise Data Connection failure in connecting with MariaDB

[WCD]

Hello all!

I'm creating this post to help in case someone face this error when trying to connect in new versions of MariaDB using MySQL Enterprise Data Connection, because I had a hard time trying to find a fix:

ERROR [HY000][Qlik][MySQL] Unknown system variable 'max_execution_time'

You can fix this in 3 ways:

1 - move from Qlik MySQL Enterprise Edition connector to ODBC Data Connection using MariaDB or MySQL community ODBC driver.[Qlik Sense and MariaDB - Qlik Community - 1713345]

2 - Update the Qlik MySQL Enterprise Edition connector to have this 3 advanced parameters[Solved: Qlik Sense - Timeout loading data from SQL - Qlik Community - 1219179]:

Timeout =0
ConnectionTimeout = 60000
QueryTimeout=-1

3 - Change the 'useBulkReader' property in the connection string from 'true' to 'false'(You can't change from HUB data connection editor. You need to go to QMC -> Data Connections -> Edit data connection'[Qlik Sense ODBC database connector performance inc... - Qlik Community - 1995368].