How to find the location of my.ini file for MySQL Server on Windows Machine - MySQL DBA Tutorial

How to find the location of my.ini file for MySQL Server on Windows Machine

In you have default installation on Windows machine for MySQL Server, you will be able to find the my.ini file in C:\ProgramData\MySQL\MySQL Server XX\. The XX defined the version of MySQL server. In case you have installed 8.0 then path for my.ini will look like "C:\ProgramData\MySQL\MySQL Server 8.0".

my.ini location in windows for MySQL Server 8.0

In case you have done multiple installation of MySQL Server on windows machine, the ini file location can be different from above. 

To find the ini file for any MySQL server installation on Windows Machine, you can always go to Services and then right click on MySQL service and go to Properties, you will be able to see the ini file location.

See below example, I have installed second MySQL Server and I have my.ini file on different locaiton, also I have renamed the my.ini file to mysqldev.ini. 

Watch the video demo for detail explanation, Where to find the my.ini file location on windows for default and manually installed MySQL Server.

1 comment: