Qlik MySQL Enterprise Data Connection failure in connecting with MariaDB

WCD — Fri, 29 May 2026 13:39:29 GMT

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].

topic Qlik MySQL Enterprise Data Connection failure in connecting with MariaDB in Connectivity & Data Prep

Qlik MySQL Enterprise Data Connection failure in connecting with MariaDB