mysql 如何编译my.cnf,MySQL：编辑/保存my.cnf文件

最新推荐文章于 2024-08-23 14:38:28 发布

达布斯

最新推荐文章于 2024-08-23 14:38:28 发布

阅读量440

点赞数

文章标签： mysql 如何编译my.cnf

I have found the sample configuration files provided with mysql 5.0, but I am not able to save them, when I edit them. I also tried saving using a different file name but I received an error by windows saying that I don't have permission to save file in that location (I am an administrator).

I need to edit the configuration file so I am able to save more data. I really can't figure out how to do it and have been struck on this problem since hours. anyone who can figure out whats going on?

解决方案

to edit my.cnf file in linux opensuse 11.3

first of all open terminal window in su mode

then go to the directory /etc

then open my.cnf file in any of the text editor(kwrite);

now just insert the following two parameters after the line [mysqld]

wait_timeout=50

interactive_timeout=50

save and exit;

restart mysql;

now u can set your session time out by using the following:

set wait_timeout=5000;