Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I find the file my.cnf or my.ini file? [closed]

I've read about MySQL replication and i need to change some configuration but I can't find the file my.cnf or my.ini. I don't know which MySQL version I have but I've downloaded it a long time ago, as a .zip. My box runs Windows 7 64. Where can i find this file? Should I create it? Where? Thank you.

like image 465
cudalanda Avatar asked Sep 09 '11 12:09

cudalanda


People also ask

Where is the my INI file located?

The my. ini is in hidden folder of program data. First go to C: drive and then hidden folder of program data. From that, move to the MySQL version directory.

Is my CNF same as ini?

cnf is called my. ini on Windows) file will be located will correspond to the directory where the MySQL data directory is located. On Linux, it will probably be /var/lib/mysql/my.


1 Answers

I do not have Window present at the moment, but I think it should reside in the C:\WINDOWS\ directory.

When invoking help on GNU/Linux with mysql --help it shows (excerpt):

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf 

Maybe you can get the same information on Windows, too.

Btw: with mysql --version you can get your current version.

like image 140
arnep Avatar answered Sep 26 '22 16:09

arnep