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

by

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:\Windows\my.ini 
C:\Windows\my.cnf 
C:\my.ini 
C:\my.cnf 
C:\xampp\mysql\my.ini 
C:\xampp\mysql\my.cnf 
C:\xampp\mysql\bin\my.ini 
C:\xampp\mysql\bin\my.cnf

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

More Related Contents:

  1. How can I access the MySQL command line with XAMPP for Windows?
  2. how to delete data from table A besides the customer service and director data in table B?
  3. How to solve “Error: MySQL shutdown unexpectedly”?
  4. xampp MySQL does not start
  5. mysql2 gem compiled for wrong mysql client library
  6. MySQL error 1064 syntax but everything seems fine
  7. mysql configuration stops at “starting server”
  8. Import SQL file into mysql
  9. How can I change MariaDB to MySQL in XAMPP?
  10. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  11. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  12. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  13. How repair corrupt xampp ‘mysql.user’ table?
  14. How to force case sensitive table names?
  15. MySQL my.ini location
  16. access denied for user @ ‘localhost’ to database ” [closed]
  17. How to turn on/off MySQL strict mode in localhost (xampp)?
  18. Where does MySQL store database files on Windows and what are the names of the files?
  19. XAMPP – Error: MySQL shutdown unexpectedly
  20. Xampp-mysql – “Table doesn’t exist in engine” #1932
  21. How to get back Lost phpMyAdmin Password, XAMPP
  22. How to declare a variable in MySQL?
  23. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  24. MySQL incorrect key file for tmp table when making multiple joins
  25. Does the order of conditions in a WHERE clause affect MySQL performance?
  26. Get total number of rows when using LIMIT? [duplicate]
  27. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  28. MySQL export into outfile : CSV escaping chars
  29. Creating MYSQL Procedure in Laravel 4 Migrations
  30. MySQL: Computed Column

Leave a Comment