mysql server won't stop

Question

So I have tried countless things to try to stop MySQL from running.

I've tried to stop the process but it keeps giving me this error:

Executing '/usr/local/mysql/support-files/mysql.server stop' 2013-12-23 21:08:29 - 
Stop server: ERROR! MySQL server PID file could not 2013-12-23 21:08:29 - 
Stop server: be found!

Here's a screenshot.

I've also tried the following:

Force Quitting
Activity Monitor and Force Quitting the process
Using the CLI / Terminal to Stop Process using:
- killall -KILL Finder
- killall -KILL Dock
- killall -KILL SystemUIServer
- killall -9 mysqld

result from last command:

~❯killall -9 mysqld
Password:
kill: kill 11963 failed: operation not permitted
~❯

and it still hasn't stopped running... unfortunately. I tried double checking with both the system preferences view as well as the mySQL workbench view. The system preferences says it's running. No response when I click stop. When I go to the workbench it says off and without me clicking "start" it just turns on.

So then I tried killing it and the results were as follows. Still hasn't stopped.. ugh.. (everything between the underscores below represents spacing)

~❯ps -A | grep mysql
11963 ?? _ _ _ _ . _ 0:01.27 --user=_mysql
14635 ttys000 _ _. _ 0:00:00 grep mysql
~❯sudo kill 11963
Password:
~❯

I then tried uninstalling all the MySQL files using the following commands:

- sudo rm /usr/local/mysql
- sudo rm -rf /usr/local/mysql*
- sudo rm -rf /Library/StartupItems/MySQLCOM
- sudo rm -rf /Library/PreferencePanes/MySQL*
- vim /etc/hostconfig and removed the line MYSQLCOM=-YES-
- rm -rf ~/Library/PreferencePanes/MySQL*
- sudo rm -rf /Library/Receipts/mysql*
- sudo rm -rf /Library/Receipts/MySQL*
- sudo rm -rf /var/db/receipts/com.mysql.*

All to no avail. Finally I thought if I maybe looked up all the files that had mysql in them and deleted the ones I was pretty sure were the right ones maybe this would work. So I used:

- sudo find / | grep -i mysql

Which showed all the files but still no luck.

Could anybody please help me figure this out? I feel like I'm way overdoing this.

mysql server won't stop

2 Answers