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|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|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|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|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|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|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|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|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|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|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 dire...

问MySQL my.ini位置
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL my.ini位置EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL my.ini位置
EN