mysql is not starting - [ERROR] [MY-010187] [Server] could not open file /var/log/mysql/error.log

Products

• CA API Gateway

Issue/Introduction

Mysql service do not start

 

service mysql start 

Job for mysql.service failed because control process exited with error code

see "systemctl status mysql.service" and "journalctl -xeu mysql,service" for details

Feb 26 08:53:41 ... mysql.service: Main process exited, code=exited, status=1/FAILURE

When Run : command "journalctl -xeu mysql,service" , shows : [ERROR] [MY-010187] [Server] could not open file /var/log/mysql/error.log

Environment

CA API Gateway 11.1.x

Cause

- Incorrect File Permissions at /var/log/mysql/error.log , was set as root user and group.

Resolution

-Ensure the mysql user has the correct permissions for the MySQL data and log directories.

Commands:
sudo chown mysql:adm /var/log/mysql