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 …

You can display the Data Directory using following command …

mysql> show variable like 'datadir';

Log Files

Option Files

To check location of my.cnf file use …

mysql --help | grep 'my.cnf'

On Ubuntu 18.04 this returns …

/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

Default options are read from the above files in the order given.