Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

3 Answers 3

up vote 3 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

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

share|improve this answer

after shutting down mysql service (using mysqladmin -h127.0.0.1 -uroot -p shutdown) and start it again, I could not connect to that server from external clients

I looked up the problem and I found this question, applied the answer, so that the problem is solved. that was because of waste DNS reverse query of mysqld.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.