I can not find my.cnf on my windows computer [duplicate]

by

Here is my answer:

  1. Win+R (shortcut for ‘run’), type services.msc, Enter
  2. You should find an entry like ‘MySQL56’, right click on it, select properties
  3. You should see something like "D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="D:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

Full answer here:
https://stackoverflow.com/a/20136523/1316649

More Related Contents:

  1. How can I restore the MySQL root user’s full privileges?
  2. Determine which MySQL configuration file is being used
  3. How to start MySQL with –skip-grant-tables?
  4. MySQL grant all privileges to database except one table
  5. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  6. How do you set a default value for a MySQL Datetime column?
  7. Compare two MySQL databases [closed]
  8. MySQL – Trigger for updating same table after insert
  9. Storing image in database directly or as base64 data?
  10. Implementation of Levenshtein distance for mysql/fuzzy search?
  11. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  12. MySQL – Operand should contain 1 column(s)
  13. How to get the difference in years from two different dates?
  14. Restore table structure from frm and ibd files
  15. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  16. mysql pivot/crosstab query
  17. UNION query with codeigniter’s active record pattern
  18. When to use MongoDB or other document oriented database systems? [closed]
  19. mysql stored procedure that calls itself recursively
  20. MySql views performance [closed]
  21. When to use NULL in MySQL tables
  22. How to get number of rows affected, while executing MySQL query from bash?
  23. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  24. Detecting locked tables (locked by LOCK TABLE)
  25. Mysql insert into 2 tables
  26. How do you stop MySQL on a Mac OS install?
  27. How to import large sql file in phpmyadmin
  28. Equivalent of MSSQL IDENTITY Column in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment