Set a persistent global MySQL parameter

Question

I set the following MySQL parameter:

set global wait_timeout=2147483

However, after server restart it reverted to its default value 28800. Isn't the set command persistent? In order to have this parameter persistent, should I edit a configuration file? Would that file be C:\Program Files\MySQL\MySQL Server 5.5\my.ini? If so, is it simply

wait_timeout=2147483

If so, under which section should it be in my.ini

score 14 · Accepted Answer · answered Nov 18 '11 at 08:55

14

Set global doesn't make persistent variables.

You should write that under [mysqld] section in my.cnf:

[mysqld]
wait_timeout=86400

answered Nov 18 '11 at 08:55

Samet Atdag

982
6
21

2

Is `my.ini` the Windows equivalent of linux's `my.cfg`? – Jonathan Livni Nov 18 '11 at 11:58
Yes, Mysql on Windows searches several places for settings file in this order: %WINDIR%\my.ini, %WINDIR%\my.cnf, C:\my.ini, C:\my.cnf, INSTALLDIR\my.ini, INSTALLDIR\my.cnf – Samet Atdag Nov 18 '11 at 13:08
See [follow up question](http://stackoverflow.com/questions/8200825/mysql-config-both-for-global-and-for-session) – Jonathan Livni Nov 20 '11 at 10:13

Set a persistent global MySQL parameter

1 Answers1

Linked