MySQL my.ini location

by

my.ini LOCATION ON WINDOWS MYSQL 5.6 MSI (USING THE INSTALL WIZARD)

Open a Windows command shell and type: echo %PROGRAMDATA%. On Windows Vista this results in: C:\ProgramData.

According to http://dev.mysql.com/doc/refman/5.6/en/option-files.html, the first location MySQL will look under is in %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini. In your Windows shell if you do ls "%PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini", you will see that the file is there.

Unlike most suggestions you will find in Stackoverflow and around the web, putting the file in C:\Program Files\MySQL\MySQL Server 5.6\my.ini WILL NOT WORK. Neither will C:\Program Files (x86)\MySQL\MySQL Server 5.1. The reason being quoted on the MySQL link posted above:

On Windows, MySQL programs read startup options from the following
files, in the specified order (top items are used first).

The 5.6 MSI installer does create a my.ini in the highest priority location, meaning no other file will ever be found/used, except for the one created by the installer.

The solution accepted above will not work for 5.6 MSI-based installs.

More Related Contents:

  1. mysql2 gem compiled for wrong mysql client library
  2. How can I access the MySQL command line with XAMPP for Windows?
  3. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  4. mysql configuration stops at “starting server”
  5. Import SQL file into mysql
  6. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  7. How to force case sensitive table names?
  8. Where does MySQL store database files on Windows and what are the names of the files?
  9. Xampp-mysql – “Table doesn’t exist in engine” #1932
  10. Delimiters in MySQL
  11. How to store Emoji Character in MySQL Database
  12. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  13. MySQL: Quick breakdown of the types of joins [duplicate]
  14. Any way to select without causing locking in MySQL?
  15. Log all queries in mysql
  16. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  17. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  18. How to convert timestamp to datetime in MySQL?
  19. MySQL varchar index length
  20. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  21. Best practices for SQL varchar column length [closed]
  22. MySQL – Fetching lowest value
  23. What are differences between INSERT and UPDATE in MySQL?
  24. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  25. How to alias a field or column in MySQL?
  26. How to delete duplicate rows from a MySQL table
  27. mysql: why comparing a ‘string’ to 0 gives true?
  28. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  29. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  30. SELECT INTO Variable in MySQL DECLARE causes syntax error?

Leave a Comment