MySQL my.ini位置 [英] MySQL my.ini location

问题描述

我已经看过 http://dev.mysql.com /doc/refman/4.1/en/mysql-config-wizard-file-location.html

如何知道mysql my.cnf位置

和

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屋！