Setting a variable that was added in a newer MySQL version than is installed. Setting a variable that was removed or renamed between MySQL versions. Typo in the variable name. Using a MySQL 8.0 variable on a MySQL 5.7 server

Step 1: Check if the variable exists in the current MySQL version: `SHOW VARIABLES LIKE '%variable_name%';`. Step 2: Verify the MySQL version: `SELECT VERSION();` and check the variable's version support in MySQL documentation.. Step 3: Use the correct variable name for the installed MySQL version — refer to the MySQL 8.0 or 5.7 system variable reference.

Medium severityconfiguration

Power BI Refresh Error:
1193

What does this error mean?

A SET statement references a MySQL system variable that does not exist in the installed MySQL version.

Common causes

1Setting a variable that was added in a newer MySQL version than is installed
2Setting a variable that was removed or renamed between MySQL versions
3Typo in the variable name
4Using a MySQL 8.0 variable on a MySQL 5.7 server

How to fix it

1Step 1: Check if the variable exists in the current MySQL version: `SHOW VARIABLES LIKE '%variable_name%';`
2Step 2: Verify the MySQL version: `SELECT VERSION();` and check the variable's version support in MySQL documentation.
3Step 3: Use the correct variable name for the installed MySQL version — refer to the MySQL 8.0 or 5.7 system variable reference.

Frequently asked questions

How do I find all available MySQL system variables?

Run `SHOW GLOBAL VARIABLES;` to list all system variables available on the current MySQL server.

Which MySQL variables changed between 5.7 and 8.0?

Notable changes: `query_cache_size` and `query_cache_type` were removed in 8.0, `innodb_file_format` was removed, and many replication variables were renamed. Check the MySQL 8.0 release notes for the full list.

Can MetricSign detect when a variable setting error breaks a pipeline?

Yes — MetricSign captures ADF Stored Procedure activity failures and surfaces the MySQL error code in the incident detail.

Official documentation: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html