Set MySQL constant global parameter

I set the following MySQL parameter:

set global wait_timeout=2147483 

However, after rebooting the server, it returned to the default values ​​of 28800. Does the set command work? To keep this setting constant, should I change the configuration file? Will this file be C:\Program Files\MySQL\MySQL Server 5.5\my.ini ? If yes, then just

 wait_timeout=2147483 

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

+4
source share
1 answer

Setting global does not create constant variables.

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

 [mysqld] wait_timeout=86400 
+11
source

Source: https://habr.com/ru/post/1381854/


All Articles