MySQL is currently set to a wait_timeout of 28800 on our server which I understand to be the default. I've been attempting to change this to 60 as recommended by a consultant, but the changes don't seem to take for long. Here's what I've tried while logged into Linux as root and MySQL as a database user:
1) Logging into MySQL and:
show variables like '%wait_timeout%'; set wait_timeout=60;
2) Editing the my.cnf file under /etc and adding the following line to both [mysqld] and [mysqld_safe]:
When I try #1 and choose to show the wait_timeout variable right after, it shows correctly as 60. However, if I wait a minute or two, it reverts back to 28800 again. When I try #2, the option doesn't seem to take at all, even after restarting Apache and MySQL.
The my.cnf seems to be the only such version of the file that I can find.
I've tried the following, but no arguments show:
When restarting Apache, I've been using:
When restarting MySQL, I've been using:
Any ideas? :-(