I can not find my.cnf on my windows computer

Question

My computer is Windows XP.

I need to find my.cnf to get all privileges back to the root user. I accidentally removed some privileges of the root user. I still have the password and there is no problem for me to log in to MySQL as the root user. But I can not alter a table.

score 239 · Answer 1 · edited Jul 16 '18 at 22:10

239

Here is my answer:

Win+R (shortcut for 'run'), type services.msc, Enter
You should find an entry like 'MySQL56', right click on it, select properties
You should see something like "D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="D:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

Full answer here: https://stackoverflow.com/a/20136523/1316649

edited Jul 16 '18 at 22:10

Richard

4,341
5
35
55

answered Nov 23 '13 at 02:04

fstang

5,607
4
25
26

1

what happens if mysql is not running as a service? where is the my.ini located? I can see my-default.ini on C:\Program Files\MySQL\MySQL Server 5.6 but I don't know if the server is using it. – Pablo Pazos Oct 24 '17 at 00:01
@PabloPazos Same question, what happens if we run it *not as a service*, but rather from cmdline: `mysqld --console`? – Basj Apr 19 '23 at 18:13

score 84 · Answer 2 · edited Nov 11 '15 at 16:20

84

To answer your question, on Windows, the my.cnf file may be called my.ini. MySQL looks for it in the following locations (in this order):

%PROGRAMDATA%\MySQL\MySQL Server 5.7\my.ini, %PROGRAMDATA%\MySQL\MySQL Server 5.7\my.cnf
%WINDIR%\my.ini, %WINDIR%\my.cnf
C:\my.ini, C:\my.cnf
INSTALLDIR\my.ini, INSTALLDIR\my.cnf

See also http://dev.mysql.com/doc/refman/5.7/en/option-files.html

Then you can edit the config file and add an entry like this:

[mysqld]
skip-grant-tables

Then restart the MySQL Service and you can log in and do what you need to do. Of course you want to disable that entry in the config file as soon as possible!

See also http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

edited Nov 11 '15 at 16:20

Zitrax

19,036
20
88
110

answered Nov 11 '09 at 02:46

Bill Karwin

538,548
86
673
828

22

For me it was: `C:\ProgramData\MySQL\MySQL Server 5.5\my.ini` – Petah Nov 22 '12 at 04:16
3

I am using xampp and mine is found in C:\xampp\mysql\bin\my.ini – Asuka165 Dec 22 '15 at 20:34

score 13 · Answer 3 · edited Aug 12 '13 at 04:18

13

Windows 7 location is: C:\Users\All Users\MySQL\MySQL Server 5.5\my.ini

For XP may be: C:\Documents and Settings\All Users\MySQL\MySQL Server 5.5\my.ini

At the tops of these files are comments defining where my.cnf can be found.

edited Aug 12 '13 at 04:18

Eric Leschinski

146,994
96
417
335

answered May 23 '13 at 15:30

Alberto

131
1
4

good one, i check it in Win8 also: " C:\Users\All Users\MySQL\MySQL Server 5.6 " – Enrique San Martín Sep 05 '15 at 04:53

score 6 · Answer 4 · edited Aug 24 '14 at 06:32

6

You can find the basedir (and within maybe your my.cnf) if you do the following query in your mysql-Client (e.g. phpmyadmin)

SHOW VARIABLES

edited Aug 24 '14 at 06:32

marc_s

732,580
175
1,330
1,459

answered Feb 18 '14 at 15:24

digitaldonkey

2,431
1
20
16

score 0 · Answer 5 · answered Nov 11 '09 at 02:43

0

you can search this file : resetroot.bat

just double click it so that your root accout will be reset and all the privileges are turned into YES

answered Nov 11 '09 at 02:43

Treby

1,328
6
18
26

score -6 · Answer 6 · answered Nov 11 '09 at 02:36

-6

Start->Search->For Files and Folders->All Files and Folders

type "my.cnf" and hit search.

answered Nov 11 '09 at 02:36

Jeremy Morgan

3,314
23
23

I can not find my.cnf on my windows computer

6 Answers6

Linked

Related