blocks|key|170321|text|您必须在文件夹C:\Program+Files\MySQL\MySQL+Server+5.5中查找，但有一个问题。在执行MySQL的MSI安装时，不会创建my.ini。该文件夹中将包含示例.ini文件。为了使用其中之一，例如my-medium.ini，您需要在MySQL重新启动之前执行以下操作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|170322|cd+C:\Program+Files\MySQL\MySQL+Server+5.5
copy+my-medium.ini+my.ini
net+stop+mysql
net+start+mysql|code-block|syntax|javascript|170323|一旦这样做，C:\Program+Files\MySQL\MySQL+Server+5.5\bin\mysql.exe就可以读取my.ini。|170324|entityMap^0|7|13|34|D|0|0|6|1H|1S|6|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

You have to look I the folder <code>C:\Program Files\MySQL\MySQL Server 5.5</code> 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 <code>my-medium.ini</code>, you need to do the following before a MySQL restart:

<pre><code>cd C:\Program Files\MySQL\MySQL Server 5.5
copy my-medium.ini my.ini
net stop mysql
net start mysql
</code></pre>

Once, you do this, <code>my.ini</code> can be read by <code>C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe</code>.

blocks|key|388586|text|我找到了我的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388587|\ProgramData\MySQL\MySQL+Server+8.0\|code-block|syntax|javascript|388588|(它是一个隐藏文件夹)|388589|您可以键入win%2BR并写入%25PROGRAMDATA%25来访问该文件夹，或者只启用显示隐藏文件夹。|offset|length|style|CODE|388590|entityMap^0|0|0|0|5|5|D|D|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]|$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

I've found mine in

<pre><code>\ProgramData\MySQL\MySQL Server 8.0\
</code></pre>

(It is a hidden folder)

You can type <code>win+R</code> and write <code>%PROGRAMDATA%</code> to access that folder, or just enable show hidden folder.

blocks|key|170375|text|启动MySQL工作台，然后是服务器服务器选项文件，并查看窗口底部；它将显示类似于“配置文件:+C:\ProgramData\MySQL\MySQL+->+5.6\my.ini”的内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170376|(注意"ProgramData“和"Program+Files”之间的细微差别--如果你正在寻找一个快速的答案，这很容易被掩盖。)|170377|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Start MySQL Workbench, then Server -> Options File and look at bottom of the window; it will say something like "Configuration File: C:\ProgramData\MySQL\MySQL Server 5.6\my.ini"

(And note the subtle difference between "ProgramData" and "Program Files" - easy to gloss over if you're looking for a quick answer.)

blocks|key|170451|text|仅适用于MySQL工作台用户，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170452|​|170453|📷|atomic|offset|length|170454|170455|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/fe60f374540708ce37cc19fdeed1771c.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Answered for only MySQL Workbench users,

<a href="https://i.stack.imgur.com/p1DLV.png" rel="noreferrer"><img src="https://i.stack.imgur.com/p1DLV.png" alt="enter image description here"></a>

blocks|key|388481|text|您可以在windows中的C:\ProgramData\MySQL\MySQL+Server5.6位置找到my.ini文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388482|ProgramData文件夹是一个隐藏文件夹，因此请进行相应的设置以查看该文件夹。以管理员身份打开my.ini文件进行编辑，然后保存。|388483|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You can find the my.ini file in windows at this location-
C:\ProgramData\MySQL\MySQL Server 5.6

the ProgramData folder is a hidden folder, so make the according setting to see that folder.
And open my.ini file as an administrator to edit and then save that.

blocks|key|170271|text|它在C:\Program+Files\MySQL\MySQL+Server5.5中，有各种小、中、大名的.ini文件。通常使用介质，或者根据您的需求而定。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170272|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

it is there at C:\Program Files\MySQL\MySQL Server 5.5 there are various .ini files with small, medium &amp; large names. generally medium is used or it depends on your requirement.

blocks|key|170478|text|programData是隐藏文件夹，因此您必须将选项从设置更改为显示隐藏文件夹，然后在其中的my.ini文件中进行更改。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|170479|请确保更新正确的my.ini文件，因为如果您一直更新错误的文件，可能会浪费您的大量时间。|170480|您可以查看服务，以了解此服务中配置了哪个my.ini。|170481|entityMap^0|0|B|1A|6|0|8|6|0|K|6|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

<code>programData</code> is hidden folder so you have to change the option from setting to show hidden folder and then make the change in <code>my.ini</code> file present in that. 

Be sure to update the correct <code>my.ini</code> file because it can waste a lot of your time if you keep updating wrong file. 

You can look into service to see which <code>my.ini</code> is configured in this service.

blocks|key|388689|text|按Windows键>键入服务>按enter+>在列表中查找mysql+>右键单击>属性>可执行文件的路径将在其下方显示默认文件的位置(my.ini)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388690|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Press the windows key > type services > press enter > Look up mysql in the list > right click > properties > Path to Executable will have the location of the defaults file right below it (my.ini)

blocks|key|170580|text|打开你的运行控制台类型:+services.msc查找:+mysql右键单击属性，其中写着“可执行文件的路径”，点击并向右移动光标，直到你看到my.ini的目录，它写的是“默认值-文件-”。要在浏览文件夹上手动访问它，您必须启用隐藏元素的可视化功能(浏览folder>top+menu>visualize>visualize隐藏元素)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170581|正如这段视频所解释的|170582|https://www.youtube.com/watch?v=SvCAa2XuQhg|offset|length|170583|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|17|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

Open your run console
type: services.msc
look for: mysql
right click
properties
where is written "path to executable", click and move the cursor to the right until you see the directory of my.ini, it's written "defaults-file-".
to reach it manually on your explore folders you have to enable the visualization of hidden elements (explore folder>top menu>visualize>visualize hidden elements)

as explained by this video

<a href="https://www.youtube.com/watch?v=SvCAa2XuQhg" rel="nofollow noreferrer">https://www.youtube.com/watch?v=SvCAa2XuQhg</a>

blocks|key|388507|text|我在MSI安装MySQL时遇到了同样的问题，当我尝试上述步骤时，也没有my-medium.ini文件。只有安装MySQL的ZIP文件才能帮到我。因此，我建议您卸载MSI安装文件夹，然后使用ZIP文件重新安装。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388508|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I met with the same problem when I did MSI install of MySQL and there were no my-medium.ini files too when I tried the above steps. Only installing the ZIP file of MySQL helped me. So, I suggest you to uninstall the MSI installed folder and reinstall using the ZIP file.

blocks|key|170684|text|在Windows上，如果MySQL是作为服务安装的，您可以更改该服务的二进制路径。例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170685|sc+config+MySQL57+binPath=+"\"C:\Program+Files\MySQL\MySQL+Server+5.7\bin\mysqld.exe\"+--defaults-file=\"<myini+path>"+MySQL57"|code-block|syntax|javascript|170686|binpath后的空格很重要。您必须转义双引号|170687|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

on Windows if MySQL is install as a service you can change the binpath of the service. For example

<pre><code>sc config MySQL57 binPath= "\"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe\" --defaults-file=\"&lt;myini path&gt;" MySQL57"
</code></pre>

space after binpath is important. You must escape double quotes

blocks|key|170728|text|对于MySql+Server+8.0，默认位置为%25WINDIR%25或C:\Windows。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170729|你需要在那里添加一个"my.ini“文件。|170730|下面是我放在ini文件中的一个示例。|170731|[mysqld]

secure_file_priv=""|code-block|syntax|javascript|170732|确保在此之后重新启动MySQL服务。|170733|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For MySql Server 8.0 The default location is %WINDIR% or C:\Windows.
You need to add a &quot;my.ini&quot; file there.
Here's a sample of what I put in the ini file.
<pre><code>[mysqld]

secure_file_priv=&quot;&quot;
</code></pre>
Make sure to restart the MySQL service after that.

I have already seen 
<a href="http://dev.mysql.com/doc/refman/4.1/en/mysql-config-wizard-file-location.html" rel="noreferrer">http://dev.mysql.com/doc/refman/4.1/en/mysql-config-wizard-file-location.html</a>

<a href="https://stackoverflow.com/questions/2482234/how-to-know-mysql-my-cnf-location">how to know mysql my.cnf location</a>

and 

<a href="http://dev.mysql.com/doc/refman/5.1/en/option-files.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.1/en/option-files.html</a>

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 <code>installation directory</code> or not in <code>c:\</code> neither in <code>c:\windows</code> nor in <code>data_dir</code> query <code>show variables like "mysql_home"</code> returned nothing as well.

Any suggestions?

MySQL my.ini location

SQL Server

服务器

Windows

MySQL

我已经看过了和但是我仍然被这个古老的问题所困扰！"Where is my my.ini“我使用的是带有mysql 5.5.28的windows server 2008。我使用mysqld --install安装了该服务，并且能够使用sqlyog使用mysql服务器。但不幸的是，我无法在installation directory中找到my.ini，也无法在c:\中找到，无论是在c:\windows

问MySQL my.ini位置
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL my.ini位置EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL my.ini位置
EN