Broadcom API Gateway - We're unable to connect MySQL DB. Service fail to start "World-writable config file /etc/my.cnf is ignored"

Products

• CA API Gateway

Issue/Introduction

MySQL failed to start with the following error (/var/log/mysq/error.log):

2025-04-22T23:48:19.139258Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2025-04-22T23:48:19.139268Z 1 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2025-04-22T23:48:19.139279Z 1 [ERROR] [MY-012646] [InnoDB] File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
2025-04-22T23:48:19.139290Z 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
2025-04-22T23:48:19.831001Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-commercial) starting as process 3167
2025-04-22T23:48:19.839639Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-22T23:48:19.892760Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2025-04-22T23:48:19.892795Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.

Error in MySQL console: World-writable config file /etc/my.cnf is ignored

Environment

Broadcom API Gateway 11.x

Cause

MySQL is ignoring /etc/my.cnf during startup because permissions on the file were changed by the user (permissions were set to 777 which is too open and considered a security risk). Hence starts with default settings and fails to find ibdata1.  

Resolution

- set correct permission to my.cnf 

# chmod 644 /etc/my.cnf

- restart MySQL

# systemctl restart mysql