mysql﹥ show global variables like 'wait_timeout';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| wait_timeout | 28800 |
+---------------+---------+
我们只要修改mysql5的配置文件“my.ini”(mysql5 installation dir),增加一行:
wait_timeout=31536000interactive_timeout=31536000
重启生效,需要同时修改这两个参数。