How to Enable or Set the Error Log in MySQL® or MariaDB

Introduction

You may find that MySQL is not logging its errors into an error log or is logging into an unexpected file. This can happen if the MySQL configuration file does not explicitly set the error log or has the error log set incorrectly.

Procedure

To explicitly set the MySQL/MariaDB error log, you need to log into your server via SSH as 'root.' Or through the WHM: Terminal feature.

For MySQL:

1. Open /etc/my.cnf in a text editor, such as nano or vi.
2. Add the following line below the [mysqld] section.

   log-error=/var/log/mysqld.log

3. Restart MySQL using the following command.

   /scripts/restartsrv_msyql 

For MariaDB:

1. Open /etc/my.cnf in a text editor, such as nano or vi.
2. Add the following line below the [mariadb] section.

   log_error=/var/log/mysqld.log

3. Restart MySQL using the following command.

   /scripts/restartsrv_msyql