Mysql - Problems changing the "max_execution_time" variable

Question

I have a Mysql Server 5.7 installed on a Windows server, when I change the variable "max_execution_time" to 6000, when I run the query below with ODBC to confirm that the change was made:

show variables like '%max_execution%';

The following value is returned: 30000

Queries used to change variable value:

SET max_execution_time = 60000;

SET GLOBAL max_execution_time = 60000;

SET SESSION max_execution_time = 60000;

Note: This problem only happens with ODBC, because I did the same test with php and return value was 60000.

Does anyone have any idea what it might be?

Answer 1

I found a solution to this case. Mysql ODBC driver 5.3.6 or later does not assimilate the configuration of the 'max_execution_time' variable of Mysql servers 5.7.4 or later. I solved my problem by installing version 5.1 of Mysql ODBC driver.