👀 Views: 25 💬 Answers: 1 📅 Created: 2025-06-09

mysql centos systemd bash

I'm performance testing and I'm working on a personal project and I'm trying to start MySQL on my CentOS 7 server, but I'm working with the behavior `need to find config-file: /etc/my.cnf`. I've checked the `/etc/my.cnf` file and it does exist, but for some reason, MySQL seems unable to find it upon startup. My configuration looks like this: ```ini [mysqld] user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/lib/mysql/mysql.sock datadir=/var/lib/mysql log-behavior=/var/log/mysqld.log ``` I've verified the ownership and permissions of the `/etc/my.cnf` file, and they are set as follows: ```bash ls -l /etc/my.cnf -rw------- 1 root root 1210 Oct 10 12:34 /etc/my.cnf ``` I've also tried restarting the MySQL service with `systemctl restart mysqld` and checked the logs at `/var/log/mysqld.log`, which indicates the same behavior message. Other configurations seem standard as well, and I haven't modified any other default settings. I've run `yum update` and made sure that MySQL is fully updated to version 5.7.39. I even tried moving the configuration to `/etc/mysql/my.cnf`, but that didn’t help either. What could be causing MySQL to unexpected result at locating its configuration file? Any insights would be greatly appreciated. What am I doing wrong? Any suggestions would be helpful.