Thursday, February 28, 2008

Mysql user logsout after few minutes

Mysql user logsout after few minutes :

few minutes of inactivity and it logs members out of mysql

nano /etc/my.cnf

add the below lines to my.cnf before

interactive_timeout=10
wait_timeout=10

add it in between

[mysqld]

[safe_mysqld]

[mysqld]
set-variable = max_connections=500
safe-show-database
set-variable = connect_timeout=15
interactive_timeout=10
wait_timeout=10
[safe_mysqld]
err-log=/var/log/mysqld.log

No comments: