Take the 2-minute tour ×

mysqld_multi stop 1 followed by (repeatedly, a few moments later)

mysqld_multi report 1 returns:

Reporting MySQL servers

MySQL server from group: mysqld1 is running

The instances work fine and when I reboot, I have to start the instances to get them to come back up (a separate issue I need to resolve), but the stop command doesn't seem to do anything.

It truly doesn't stop the instance because in the instance log file I see this: 120619 11:12:39 mysqld_safe A mysqld process already exists after trying to run start after.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

Whenever this happens, I usually try to shutdown mysql using mysqladmin

For example, to shutdown mysql running on port 3307

mysqladmin -h127.0.0.1 -P3307 -uroot -p shutdown

Once you ran that make sure, mysql on that port is indeed down like this:

mysqladmin -h127.0.0.1 -P3307 -uroot -p ping

Give it a Try !!!

share|improve this answer
mysqld_multi report should also shown as stopped after the shutdown command (if that's easier than running the ping) –  thinice Jun 19 '12 at 16:44
Thanks a bunch. Kind of forgot about that. –  gravyface Jun 19 '12 at 17:03
add comment

To stop any instance of mysqld_multi privileges should be granted to multi_admin user. Kindly check grants part also.

share|improve this answer
add comment

Your Answer


