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

mysql configuration configuration-files mysql-management database-replication
cudalanda picture cudalanda · Sep 9, 2011 · Viewed 28.5k times · Source

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.

Answer

arnep picture arnep · Sep 9, 2011

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.

Related questions

I can not find my.cnf on my windows computer

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 …

Read More
Determine which MySQL configuration file is being used

Is there a command to determine which configuration file MySQL 5.0 is currently using?

Read More
Changing Font in MySQL Workbench

I am using MySQL Workbench 5.2, the newest version as far as I know, but I simply cannot change the font. It is very inconvenient, because the default font is very small and harsh on the eyes. The appearance tab has …

Read More