Determine which MySQL configuration file is being used

by

Taken from the fantastic “High Performance MySQL” O’Reilly book:

$ which mysqld
/usr/sbin/mysqld

$ /usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"
Default options are read from the following files in the given order:
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf

More Related Contents:

  1. I can not find my.cnf on my windows computer [duplicate]
  2. SQL Query To Create View [closed]
  3. How to make MySQL table primary key auto increment with some prefix
  4. How to make MySQL handle UTF-8 properly
  5. Generate an integer sequence in MySQL
  6. MySQL with Node.js
  7. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  8. How to conduct an Accent Sensitive search in MySql
  9. MySQL: Select All Dates In a Range Even If No Records Present
  10. How to import an excel file in to a MySQL database
  11. MySQL strip non-numeric characters to compare
  12. Using MySQL query to traverse rows to make a recursive tree
  13. How to get the sizes of the tables of a MySQL database?
  14. How to shrink/purge ibdata1 file in MySQL
  15. Rails, MySQL and Snow Leopard
  16. In SQL, how to select the top 2 rows for each group
  17. MySQL CONVERT_TZ()
  18. TRIGGERs that cause INSERTs to fail? Possible?
  19. Mysql query to dynamically convert rows to columns on the basis of two columns
  20. MySQL: #126 – Incorrect key file for table
  21. MYSQL Left Join COUNTS from multiple tables
  22. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  23. MySQL my.ini location
  24. Comma separated string of selected values in MySQL
  25. MySQL InnoDB: autoincrement non-primary key
  26. How to insert a file in MySQL database?
  27. How to turn on/off MySQL strict mode in localhost (xampp)?
  28. What is wrong with my SQL here? #1089 – Incorrect prefix key
  29. Multi-Column Primary Key in MySQL 5
  30. MySql SELECT union for different columns? [duplicate]

Leave a Comment