How to resolve MySQL error with Qlik Replicate: Loading local data is disabled this must be enabled on both the client and server sides

[KellyHobson]

The following error is displayed when using MySQL as an endpoint in Qlik Replicate:

RetCode: SQL_ERROR SqlState: HY000 NativeError: 3948 Message: [MySQL][ODBC 5.3(w) Driver][mysqld-8.0.22-commercial]Loading local data is disabled; this must be enabled on both the client and server sides

Resolution

Set the variable local_infile to ON.

You can do this in the MySQL UI with this command:

SET GLOBAL local_infile=1;

Or in a command line with:

mysql> SET GLOBAL local_infile=1;

Environment

• Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.