How to active mariadb log?

Posted on

Question :

I want active log file in mariadb for check last query used in php, i find mysql config in internet like as blow:

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1

or

log = /var/log/mysql/mysql.log

I added this config in /etc/mysql/my.cnf and [mysql] section and restart mariadb service.
but i didn’t get any log, how to fix this?

i find answer:

[mysqld]
...
log_output = FILE
general_log = ON
general_log_file = mysql.log

mysql.log save in datadir, run SHOW VARIABLES WHERE variable_name = 'datadir' in mariadb to get datadir.

Answer :

You also need one of these:

log_output = FILE

log_output = TABLE

And put them in this section:

[mysqld]

(‘d’ as in ‘daemon’ as in the ‘server’)

Leave a Reply

Your email address will not be published.