where is the my.cnf file for mysql server located on windows?

13,131

Here's the location with MySQL Server 5.7:

C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
Share:
13,131

Related videos on Youtube

neubert
Author by

neubert

Apparently, this user prefers to keep an air of mystery about them.

Updated on September 18, 2022

Comments

  • neubert
    neubert almost 2 years

    I'm running MySQL Server 5.6 on Windows 7 and would like to enable slow query logging. Unfortunately, it is not immediately obvious to me where the my.cnf file is.

    I see C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini but according to that...

    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.
    

    I don't see any my.cnf or my.ini file in C:\Users\neubert\AppData\Roaming\MySQL either.

    Any ideas?