MySQL server cannot be stopped

Question

I am using Ubuntu release 14.04, MySQL 14.14 Distrib 5.5.43.

To reset the MySQL root password, as described in the official MySQL doc How to reset the root password, I need to stop the MySQL server.

Using htop before killing the server, I see the following related processes: enter image description here

Then, as indicated, I stop the MySQL server with the following command: kill $(cat /var/run/mysqld/mysqld.pid).

But, a few seconds later, all associated processes are automatically restarted under different PIDs: enter image description here

How can I stop the server without it restarting new processes each time ?

score 1 · Answer 1 · answered Jun 16 '15 at 14:13

1

Try stopping the mysql server, instead of killing the process:

sudo /etc/init.d/mysql stop

answered Jun 16 '15 at 14:13

andresigualada

score 1 · Answer 2 · edited Apr 13 '17 at 12:42

You may not be aware of this, but the MySQL service is designed to be restarted automatically.

There is a program called mysqld_safe. Its job is to do the following:

Killing mysqld only makes mysqld_safe do its job.

SUGGESTION : Kill mysqld_safe first, then kill mysqld.

2 Answers2