Where is the my ini file in MySQL?

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.

Table of Contents Show

Where is my ini file in MySQL Ubuntu?
How to create my ini file in MySQL?
How do I edit a MySQL ini file?
Where is my CNF file in MySQL in Windows?

Here is the snapshot of the C: drive −

Click on C drive. The snapshot is as follows. Here, you can see the Program Data folder −

Now go to MySQL under Program Data folder. The snapshot is as follows −

Go to MySQL version. The snapshot is as follows −

Note − Here, we are using MySQL version 8.0.12

Here is the my.ini file.

In order to reach the location, you can also use the following command −

mysql> select @@datadir;

The following is the output −

+---------------------------------------------+
| @@datadir                                   |
+---------------------------------------------+
| C:\ProgramData\MySQL\MySQL Server 8.0\Data\ |
+---------------------------------------------+
1 row in set (0.00 sec)