hi list I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in version 5.0)
-bash-3.00$ mysql -e "show variables like 'wait_timeout%'" +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | *30* | +---------------+-------+ -bash-3.00$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 4.1.22-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like 'wait_timeout%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | *28800 *| +---------------+-------+ 1 row in set (0.00 sec) mysql> show global variables like 'wait_timeout%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | *30 *| +---------------+-------+ 1 row in set (0.00 sec) mysql>