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 ?

andresigualada · Accepted Answer · 2015-06-16 14:13:29Z

1

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

sudo /etc/init.d/mysql stop

answered Jun 16, 2015 at 14:13

andresigualada

111 bronze badge

Thanks, but it restarts automatically thereafter.
– Sébastien Clément
Jun 16, 2015 at 14:19
could you try the same with mysqld (instead mysql) service? Some linux distributions use different daemons
– andresigualada
Jun 16, 2015 at 14:23
root@:~# /etc/init.d/mysqld stop bash: /etc/init.d/mysqld: No such file or directory
– Sébastien Clément
Jun 16, 2015 at 14:28
try sudo stop mysql or sudo service mysql stop
– andresigualada
Jun 16, 2015 at 14:38

Add a comment |

Community · Accepted Answer · 2017-04-13 12:42:55Z

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 Answers 2