/etc/my.cnf hoặc /var/log/syslog /etc/my.cnf.d/ step1: Go to this file (/etc/mysql/conf.d/mysqld_safe_syslog.cnf) and remove or comment those line. step2: Go to mysql conf file (/etc/mysql/my.cnf) and add following lines To enable error log add following [mysqld_safe] log_error=/var/log/mysql/mysql_error.log [mysqld] log_error=/var/log/mysql/mysql_error.log To enable general query log add following general_log_file = /var/log/mysql/mysql.log general_log = 1 To enable Slow Query Log add following

Chi tiết