Steps to enable error log in MySQL database

K

kumkumsharma

Administrator
Staff member
If you want to enable mysql error log then explicitly you have to enable option /etc/my.cnf file and after that you have to restart mysql service.

You have to follow below steps:
  • Login to server via SSH as root.
  • Here check your /etc/my.cnf file and add below line in [mysqld] section.
Code: 
log-error=/var/log/mysqld.log
  • If you are working on MariaDB server then you have to modify /etc/my.cnf file and add below line in MariaDB section:
  • Add the following line below the [mariadb] section:
Code: 
[mariadb]
log_error=/var/log/mysqld.log
  • Save my.cnf file and restart MySQL.
Code: 
/scripts/restartsrv_msyql
 
You must log in or register to reply here.
Top