MySQL configurations are not saved after restarting windows server machine

Question

I have a PHP application hosted on a windows server 2008 R2 machine.

I had a problem with strict mode in MySQL and solved it by disabling the strict mode using the following command

set GLOBAL.sql_mode='';

When I restart the machine, strict mode is enabled again and the problem exists again.

How can I solve this issue ?

Edit:

In addition to @Jérémy Munoz's answer, you have to restart the MySQL service using the following commands:

net stop MySQL

then

net start MySQL

By reading the [documentation](http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sql-mode-setting)? — Sven, Mar 09 '15 at 12:46

score 2 · Accepted Answer · edited May 08 '15 at 08:54

2

Add this : sql-mode="what you want" below [mysqld] in the my.cnf configuration file.

edited May 08 '15 at 08:54

René Höhle

1,438
3
17
26

answered Mar 09 '15 at 13:26

Jérémy Munoz

344
2
8

That worked for me, I was adding it under [mysql] But what is the difference ?? Thanks ! – Hazem Taha Mar 09 '15 at 14:32

score 0 · Answer 2 · edited Mar 09 '15 at 13:19

0

Write the command into the MySQL Server config file.

edited Mar 09 '15 at 13:19

HBruijn

77,029
24
135
201

answered Mar 09 '15 at 12:47

Sven

98,649
14
180
226

Of course I tried this approach, I wrote sql-mode="" but did not work. Still losing changes after restarting. – Hazem Taha Mar 09 '15 at 13:03

score 0 · Answer 3 · answered May 08 '15 at 07:00

0

I had a similar problem. It happened that there were several my.cnf files in system. One in /etc/mtsql and other in /usr/. And latter had bad parameters.

answered May 08 '15 at 07:00

Ivan Ivanov

101
2

MySQL configurations are not saved after restarting windows server machine

3 Answers3