You can retrieve the current global or session sql_mode value with the following statements:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

And set it with :
Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
Start MySQL with the option --sql-mode="MYSQL40"
Execute the query SET GLOBAL sql_mode='MYSQL40'