Systemd Mysql won't stop
I had the same problem (upgrade to 15.04, using official files and config).
I had to make the following changes to be able to stop the mysql
daemon manually with sytemctl
and automatically on system reboot/shutdown:
Make
/etc/mysql/debian.cnf
readable for themysql
user withsudo chgrp mysql /etc/mysql/debian.cnf; sudo chmod 640 /etc/mysql/debian.cnf
Provide a slightly modified
mysql.service
file:sudo cp /lib/systemd/system/mysql.service /etc/systemd/system/ sudo chmod 755 /etc/systemd/system/mysql.service
Provide an explicit stop command by opening the copied file in an editor:
sudo nano /etc/systemd/system/mysql.service
and adding the following line under the
[Service]
section:ExecStop=/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf shutdown
In Nano, use Ctrl+O to save (Linux way!), Ctrl+X to exit.
Make the new service file known to system:
sudo systemctl daemon-reload