hi, i have problem with automatic setting of variable wait_timeout. mysql version 4.0.20 (and 4.0.18) on slackware linux. i've tried to set it in several ways:
1) in startup script as a parameter to mysql_safe: -O wait_timeout=30
2a) in configuration file /etc/my.cnf, section [mysqld]: set-variable=wait_timeout=30
2b) in configuration file /etc/my.cnf, section [mysqld]: wait_timeout=30
3) from the shell (i've planed to place it into the startup script after mysqld_safe start):
mysql -e 'set wait_timeout=30'
nothing worked, i got no error message and the value of wait_timeout stood default: 28800.
when i run 'set wait_timeout=30;' as privileged user in interactive mysql session (running 'mysql'), the value changes as i wish.
what should i do to set the variable at startup?
thanks, rudolf
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
