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:
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