Differences

This shows you the differences between two versions of the page.

--- mysqlfilesdirectories [2019/02/18 11:39] – [Linux] z0hpvk
+++ mysqlfilesdirectories [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 16: / Line 16: @@
 mysql> show variable like 'datadir';
 </code>
+=== Log Files ===
+  * [[https://dev.mysql.com/doc/refman/5.7/en/error-log.html | Error Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/query-log.html | General Query Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/binary-log.html | Binary Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/slave-logs-relaylog.html | Slave Relay Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html | Slow Query Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html | DDL Log]]
+=== Option Files ===
+To check location of my.cnf file use ...
+<code>
+mysql --help | grep 'my.cnf'
+</code>
+On Ubuntu 18.04 this returns ...
+<code>
+/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
+</code>
+Default options are read from the above files in the order given.