HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Unable to shut down MySQL server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
shutunablemysqldownserver

Problem

I have tried using the system preferences and then shutting down MySQL there, but to no avail. I also tried typing killall -9 and -11. Both failed :(.

I also tried /usr/local/mysql/bin/mysqladmin -u root -p shutdown. The last thing I tried is in the following screenshot... it also did not work.

I am using yosemite, if that matters.

Solution

Ideally you can shutdown using

/etc/init.d/mysqld stop


I cannot add comments so requesting to post what do you see in error log when you do

mysqladmin shutdown


About kill commands please note that mysqld_safe is wrapper script which will start mysqld upon killing... so you should kill mysqld_safe first followed by mysqld. ( not a suggested way though).

Refer: how to stop mysql on mac

Code Snippets

/etc/init.d/mysqld stop
mysqladmin shutdown

Context

StackExchange Database Administrators Q#107458, answer score: 3

Revisions (0)

No revisions yet.