MySQL:编辑/保存my.cnf文件 [英] mySQL: editing/saving my.cnf file

问题描述

我找到了mysql 5.0随附的示例配置文件，但是在编辑它们时无法保存它们.我也尝试使用其他文件名进行保存，但是windows收到错误消息，提示我无权在该位置(I am an administrator)保存文件.

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?

推荐答案

在Linux opensuse 11.3中编辑my.cnf文件
首先以su模式打开终端窗口
然后转到目录/etc
然后在任何文本编辑器中打开my.cnf文件(kwrite);
现在只需在[mysqld]

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

保存并退出；
重新启动mysql;
现在，您可以使用以下命令设置会话超时:

save and exit;
restart mysql;
now u can set your session time out by using the following:

set wait_timeout=5000;<br>

它是持久性的

it is persistent

这篇关于MySQL:编辑/保存my.cnf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！