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.

1 Reply

Linode Staff

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:

  1. Create the mariadb.service.d file for systemd
mkdir -p /etc/systemd/system/mariadb.service.d/
  1. Turn on "debug" level logging
sudo tee /etc/systemd/system/mariadb.service.d/syslog.conf <<EOF
[Service]
Environment=SYSTEMD_LOG_LEVEL=debug
EOF
  1. Reload the systemd daemon to refresh the changes.
systemctl daemon-reload
  1. 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:

df -h

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct