开发者

unable Setting mysql wait_timeout variable value

I am trying to set the MYSql environment vari开发者_开发知识库able wait_timeout.When I am doing through the mysql prompt using

mysql>set wait_timeout =10;

it gets reflected in the current prompt only and is not reflected globally(from the outside of the current prompt). I also tried to set it from the outside the mysql prompt using command:

set wait_timeout=10;

but again this didnot worked for me. I am using Debian(Linux),Please tell me how I can the Wait_timeout so that it would get reflected globally in mysql server.


Did you try setting it in /etc/my.cnf?

See this link for more info. Here's a "non-bug" that explores that setting that might be helpful.


Please use this command "set global wait_timeout =10". It will work.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜