Ubuntu can't stop mysqld

Question

I try running service mysql stop, killall -s SIGKILL mysqld, /etc/init.d/mysql stop, and stop mysql, but still I see this output from ps aux | grep mysql:

root     32302  0.0  0.3  59040  2120 pts/8    S    06:03   0:00 sudo mysqld_safe
root     32305  0.0  0.1   4440   772 pts/8    S    06:03   0:00 /bin/sh /usr/bin/mysqld_safe
mysql    32651  0.1  6.8 426740 41388 pts/8    Sl   06:03   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

Answer 1

The only thing that worked for me is partially explained here.

If everything else fails, try this:

root@myhost:/usr/bin# initctl --system stop mysql

After that you can start controlling mysql normally using

root@myhost:/usr/bin# /etc/init.d/mysql start

Or

root@myhost:/usr/bin# initctl --system start mysql

Answer 2

You can use pkill mysqld

Linux man page: pkill