What is the location of mysql client ".my.cnf" in XAMPP for Windows?

Question

What is the location of mysql client .my.cnf using XAMPP in Windows?

Clarification: This file does not exist by default, so when you create it, where should you place it, in order for the command line client to read it automatically?

Answer 1

Type this:

mysql --help 

Then look at the output. There is a block of text about 3/4 the way down describing what files it finds its defaults .my.cnf from. Here is an example from XAMPP v3.2.1:

Default options are read from the following files in the given order:
C:Windowsmy.ini C:Windowsmy.cnf C:my.ini C:my.cnf C:xamppmysqlmy.ini C:xamppmysqlmy.cnf C:xamppmysqlinmy.ini C:xamppmysqlinmy.cnf

Your setup may differ. You will have to run the command to check the actual paths on your particular system.