MySQL set connection time-out parameter: wait_timeout

[Email protected] ~]# mysql-h 192.168.0.*-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 8174
Server version:5.1.73 Source Distribution

Copyright (c) and/or, Oracle, its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql> show global variables like ' wait_timeout ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| Wait_timeout | 28800 |
+---------------+-------+
1 row in Set (0.00 sec)

mysql> set global wait_timeout=86400;
Query OK, 0 rows Affected (0.00 sec)

Mysql> show global variables like ' wait_timeout ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| Wait_timeout | 86400 |
+---------------+-------+
1 row in Set (0.00 sec)

Mysql>

MySQL set connection time-out parameter: wait_timeout