Solution to the error reported by Mysql systemctl start mysqld

Error message:

Job for mysqld.service failed because the control process exited with error code. See “systemctl status mysqld.service” and “journalctl -xe” for details.

Positioning error:

vim /var/log/mysqld.log #View log information

See the last line (shift+G)

Cause Analysis:

The MySQL data storage location was changed to the data disk address, the machine was restarted, and the disk mount was not set to automatically mount at startup, resulting in the PID file not being found.

Solution: 1. Check the location of pid-file in /etc/my.cnf

vim /etc/my.cnf 

2. Create the corresponding directory and modify the permissions

mkdir -p /var/run/mysqld
chown mysql.mysql /var/run/mysqld

Now you can try to restart MySQL. If it can start, then it is ok. If it still doesn’t work, continue to step 3.

3. Create a pid file and modify permissions

touch /var/run/mysql/mysqld.pid
chown mysql.mysql /var/run/mysql/mysqld.pid

There should be no problem starting MySQL again!

This is only a temporary solution. If the virtual machine is restarted, the operation will need to be repeated. There is no solution to the fundamental problem yet, so please suspend the virtual machine temporarily. The article will be updated when a solution is found later!

This is the end of this article about solving the problem of Mysql systemctl start mysqld error. For more related content about solving the problem of Mysql systemctl start mysqld error, please search the previous articles of 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!