===== Installed Files and Directories =====

==== Linux ====

=== Data Directory ===
On Ubuntu this defaults to **/var/lib/mysql** \\
A separate directory will be created for each database, apart from INFORMATION_SCHEMA. \\ 
Also stored here by default are ...
  * Log Files 
  * InnoDB tablespace and log files 
  * SSL and RSA certificate and key files
  * The server process ID file

You can display the Data Directory using following command ...
<code>
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.