MySQL my.ini位置 [英] MySQL my.ini location
问题描述
我已经看过 http://dev.mysql.com /doc/refman/4.1/en/mysql-config-wizard-file-location.html
和
http://dev.mysql.com/doc/refman/5.1/en/option-files.html
但是我仍然对这个古老的问题感到困惑!
我的my.ini在哪里"
我正在使用Windows Server 2008和mysql 5.5.28.我使用mysqld --install安装了服务,并且能够使用sqlyog使用mysql服务器.但是不幸的是,我无法在installation directory
中找到my.ini或在c:\
中都找不到,而在c:\windows
或data_dir
查询中都找不到show variables like "mysql_home"
.
But I am still stuck with the ages old question!
"Where is my my.ini"
I am using windows server 2008 with mysql 5.5.28. I installed the service using mysqld --install and I am able to use the mysql server using sqlyog. But unfortunately I am not able to find my.ini in installation directory
or not in c:\
neither in c:\windows
nor in data_dir
query show variables like "mysql_home"
returned nothing as well.
有什么建议吗?
推荐答案
您必须查看文件夹C:\Program Files\MySQL\MySQL Server 5.5
,但是存在问题.当您执行MySQL的MSI安装时,不会创建my.ini.该文件夹中将有示例.ini文件.为了使用其中之一,例如my-medium.ini
,您需要在MySQL重新启动之前执行以下操作:
You have to look I the folder C:\Program Files\MySQL\MySQL Server 5.5
but there is a problem. When you perform an MSI install of MySQL, my.ini is not created. There will be sample .ini files in that folder. In order to use one of them, say my-medium.ini
, you need to do the following before a MySQL restart:
cd C:\Program Files\MySQL\MySQL Server 5.5
copy my-medium.ini my.ini
net stop mysql
net start mysql
执行此操作后,C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
即可读取my.ini
.
Once, you do this, my.ini
can be read by C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
.
这篇关于MySQL my.ini位置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!