CODEWITHSUNDEEP
mysqlsql
Raghav Rathi
Raghav Rathi

Reputation: 115

Unable to find my.ini file on my computer

I want to set lower_case_table_names=2 in MySQL so that I can use upper case characters for defining column names in tables.

Most answers on stack overflow have asked to add lower_case_table_names=2 in "my.ini" file. I'm not able to find this file on my computer.

edit- There is no ProgramData folder in C drive.

Upvotes: 0

Views: 548

Answers (3)

Luuk
Luuk

Reputation: 14920

D:\TEMP>wmic service Mysql80 get Pathname
PathName
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="D:\MySQL Server 8.0\my.ini" MySQL80

The default for Mysql80 point, on my computer, to: D:\MySQL Server 8.0\my.ini.

If you do not know the exact name of the service, you can also do:

wmic service get Pathname | findstr /i mysql

this will display (again, on my computer):

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="D:\MySQL Server 8.0\my.ini" MySQL80

Upvotes: 0

Basu_C
Basu_C

Reputation: 410

File with extension .ini remains hidden. Type C:\ProgramData in the address bar. It should open the ProgramData directory/folder.

Upvotes: 1

nbk
nbk

Reputation: 49375

It is hidden from view.

But you can change it

by changing the settings

Under Advanced settings, select Show hidden files, folders, and drives, and then select OK.

Upvotes: 0

Related Questions