How do I set wait_timeout to unlimited in mysql?

Question

You can not set the wait_timeout to unlimited.
– Rinzwind
Mar 14, 2017 at 15:51 — Rinzwind, Mar 14, 2017 at 15:51

muru · Accepted Answer · 2017-03-14 14:27:00Z

6

Edit my.cnf (the MySQL configuration file).

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

Locate the timeout configuration and adjust it to fit your server.
```
[mysqld]
wait_timeout = 31536000
interactive_timeout = 31536000
```
Save the changes and exit the editor.
Restart MySQL to apply the changes as follows:
```
sudo /etc/init.d/mysql restart
```

muru

198k55 gold badges485 silver badges741 bronze badges

answered Mar 14, 2017 at 10:20

Saddam ZEMMALI

1471 gold badge1 silver badge7 bronze badges

That is setting it to the max allowed value (in seconds). High, yes. But not unlimited.
– Rinzwind
Mar 14, 2017 at 15:53

Add a comment |

tyrantqiao · Accepted Answer · 2018-04-02 15:14:32Z

In my case, when I alter /etc/*/my.cnf, it would cause a lot of bugs. So I change to use mysql command to change it.

change the timeout

SET @@GLOBAL.interactive_timeout=31536000

windows timeout default is 31536000, you can choose the time you like And the way to see the timeout is show global variables like 'wait_timeout'

2 Answers 2