gdraheim
Hi MySql services can't start
i am using a WSL and CentOS, you know ,systemctl failed ,one answer refer me to here,the script can list , but no of the services can work , for instance ,my sql 5.7
@zfk513 you need to create the directory at /var/run/mysqld and then give the permissions as below chown mysql:mysql /var/run/mysql
Also, you would have to do it every time you restart the LxssManager service or reboot the machine.
This is happening because /var/run is a volatile directory and somehow it is not able to find/create mysqld.pid file in /var/run/mysqld and hence it is failing. if it still doesn't work look for the logs at /var/logs/mysqld.log.
Is it expecting that the directory gets created by the service-manager?
Please include "systemctl cat mysqld" and show the logs for "systemctl start mysqld -vvvv"
My own tests did include a lamp-stack with mariadb instead of mysqldb
https://github.com/gdraheim/docker-systemctl-images/blob/master/centos-lamp-stack.dockerfile
Here are the results
systemctl cat mysqld:
systemctl start mysqld -vvv:
It seems that systemctl.py has done its share, so one would need to inspect the mysql log what it was missing. I wonder why mysqld_pre_systemd needs to be run as root - surely systemctl.py does not implement PremissionsStartOnly=true. (another peculiar feature of systemd I guess).