Unable to start mysql - no such process
After rebooting my Centos7 server, I am no longer able to start MySQL:
systemd: Starting LSB: start and stop MariaDB... mysql: Starting MariaDB.190712 10:23:33 mysqld_safe Logging to example.com mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql ../etc/rc.d/init.d/mysql: line 260: kill: (4459) - No such process mysql ERROR! systemd: mysql.service: control process exited, code=exited status=1 systemd: Failed to start LSB: start and stop MariaDB. systemd: Unit mysql.service entered failed state. systemd: mysql.service failed.
The error messages above don't give a whole lot to go on. As an initial step, I'd suggest turning on higher verbosity. Since you are starting mysql via systemd, you'll want to do the following:
- Create the mariadb.service.d file for systemd
mkdir -p /etc/systemd/system/mariadb.service.d/
- Turn on "debug" level logging
sudo tee /etc/systemd/system/mariadb.service.d/syslog.conf <<EOF [Service] Environment=SYSTEMD_LOG_LEVEL=debug EOF
- Reload the systemd daemon to refresh the changes.
- Now, restart mysql again and check journalctl for further errors:
journalctl -u mariadb
As always with database issues, ensure that you have sufficient disk space available: