Finding MariaDB Log Location

First, enter the MariaDB CLI,

mysql -u root -p

Next, to find out your current log file path, use the following SQL query,

show global variables like 'log_error';

The output should look something like this:

Variable_name Value
log_error /var/log/mysqld.log

As seen in the above output, your file log will be located at /var/log/mysqld.log


CrownCloud - Get a SSD powered KVM VPS at $4.5/month!
Use the code WELCOME for 10% off!

1 GB RAM / 25 GB SSD / 1 CPU Core / 1 TB Bandwidth per month

Available Locations: LAX | MIA | ATL | FRA | AMS