Where can I find the file my.ini file for windows mysql server?

Question

The same question is repeated again and again and i am another one repeating this question . I have already set up my mysql server . Its location is C:\Program Files\MySQL\MySQL Server 5.5 but i am not able to find the my.ini file inside the above path . When i type the command c:>mysql --help The output looks like

Default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\M ySQL Server 5.5\my.ini C:\Program Files\MySQL\MySQL Server 5.5\my.cnf The following groups are read: mysql client

But when I opened the above locations from where it is reading these files ,I am unable to locate the file . Can anyone tell me what is the exact way to retireve the my.ini file for WINDOWS?

sorry for my bad formatting and english – gaurav Dec 06 '11 at 17:21 — gaurav, Dec 06 '11 at 17:21

Iván Quiñones · Answer 1 · 2013-12-11T16:21:29.120

14

In MySQL 5.5 Windows the default path for my.ini is C:\ProgramData\MySQL\MySQL Server 5.5

You may need to change your file browser (windows explorer) options to show hidden files and directories.

edited Dec 11 '13 at 16:21

answered Jan 19 '13 at 00:29

Iván Quiñones

501
4
12

3

You may execute the SQL query `SHOW VARIABLES` on the database to see, whether the values of your INI file actually were read in successfully. – Uwe Keim Feb 21 '13 at 00:10
Good answer, because it says where the configuration file is placed initially instead where it should be placed. – StanE May 03 '15 at 01:38

score 7 · Accepted Answer · answered Dec 06 '11 at 17:37

7

To configure the client and utility applications, create a new my.ini file in the Windows installation directory. More info here

answered Dec 06 '11 at 17:37

Bala

4,427
6
26
29

Great Boss thanks for the solution ,i din't find the solution anywhere – gaurav Dec 06 '11 at 18:12
And renaming one of predefined config files, for example my-small.ini to my.ini is even simplier. – Piotr Sobczyk Dec 06 '11 at 20:57
2

Have a look at your Service entry for where MySQL is pointing to the my.ini file and you may be surprised! I found mine in `C:\ProgramData\MySQL\MySQL Server 5.6` – Andre Van Zuydam Jul 15 '15 at 15:02

score 1 · Answer 3 · answered Jan 07 '13 at 08:15

1

Under the Data folder my friend. Go one dir up from Mysql 5.5

answered Jan 07 '13 at 08:15

Chux18

61
1
1
5

score 1 · Answer 4 · answered Sep 25 '16 at 15:03

1

Check variable datadir, in my default setup of 5.7 on Windows 7 it used:

C:\ProgramData\MySQL\MySQL Server 5.7

answered Sep 25 '16 at 15:03

Jose Manuel Gomez Alvarez

1,972
22
29

Piotr Sobczyk · Answer 5 · 2011-12-06T17:37:46.587

1

I just checked my installation and located my.ini at C:\Program Files\MySQL\MySQL Server 5.5 which seems to be exactly the same like your installation path (and mysql version is the same for us). Are you sure it isn't there?

EDIT:

Possibly all you have to do is to rename one of example .ini files to my.ini (and optionally tune it to your needs), see: http://dev.mysql.com/doc/refman/5.1/en/option-files.html#option-files-preconfigured . These are: my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf in your mysql installation dir. It is possible that this is just what I did in my case - it was a while ago when I installed mysql.

edited Dec 06 '11 at 17:37

answered Dec 06 '11 at 17:32

Piotr Sobczyk

6,443
7
47
70

:Yes i am sure ,so many people have asked the same question regarding this ,they are also not able to locate the my.ini file – gaurav Dec 06 '11 at 17:36
@gaurav These are just example versions of my.ini. Renaming one of them to my.ini is even simplier than creating new my.ini file from scratch like Balamurugan K suggested. – Piotr Sobczyk Dec 06 '11 at 20:55

score 0 · Answer 6 · edited Oct 21 '12 at 16:34

0

Just visit: http://opensourcedba.wordpress.com/2011/01/12/mysql-basics-part-3-%E2%80%93-your-my-cnf-or-my-ini-file/?blogsub=confirming

This has the whole content required for my.ini.

edited Oct 21 '12 at 16:34

Ollie

544
4
22

answered Jun 05 '12 at 10:02

alfred makari

1

score 0 · Answer 7 · answered Dec 07 '15 at 01:21

0

If you do not see my.ini file. Rename one of below file to my.ini

my-huge.ini
my-large.ini
my-medium.ini
my-small.ini

answered Dec 07 '15 at 01:21

Kris

719
1
11
19

1

What about `my-default.ini`? – Yousha Aleayoub Oct 03 '16 at 19:34

score 0 · Answer 8 · answered Sep 25 '18 at 10:39

0

You can check the my.ini through the below process: 1. Through the command prompt. Type command as "Services.msc". 2. Go to MySQL56 service and right Click. Select Properties. 3. In the Properties area you will get the my.ini file path at the end.

answered Sep 25 '18 at 10:39

Vikram Gharge

187
2
7

score 0 · Answer 9 · answered Nov 28 '18 at 15:36

0

I found the my.ini file by running SHOW VARIABLES LIKE "%datadir%"; and going one directory up.

answered Nov 28 '18 at 15:36

Nick Gotch

9,167
14
70
97

Where can I find the file my.ini file for windows mysql server?

9 Answers9

Linked

Related