Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

I can't find the file "my.cnf" or "my.ini"

I installed version 8 of MySQL and I can't find the configuration file

I was reading and everyone says that it is inside the "MySQL Server x.0" folder, but in my case it does not appear, neither inside the "etc" or "bin" folder

like image 259
Marco Antonio Diaz Diaz Avatar asked Oct 28 '25 17:10

Marco Antonio Diaz Diaz


2 Answers

How I found mine was like this;

mysqld --help --verbose | grep my.cnf
like image 173
Daantje Avatar answered Oct 31 '25 08:10

Daantje


On Windows my.ini file will be auto generated when you install MySQL server. It will be located in a hidden directory ProgramData.

C:\ProgramData\MySQL\MySQL Server 8.0

In order to view these files you may need to show hidden items. To do that

Open file explorer > View > Tick Hidden Items

like image 41
Ruchira Nawarathna Avatar answered Oct 31 '25 06:10

Ruchira Nawarathna



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!