How to Stop a Runaway MySQL process on MacOS

I had this issue where a query was left running and burning up my pc resources. I saw this in the activity monitor application.

To stop it I eventually had to:

sudo mysqladmin -u root -p shutdown

You should be able to start it again by going:

cd /
sudo find . -name 'mysql.server'

then using the output

sudo /usr/local/mysql-5.7.21-macos10.13-x86_64/support-files/mysql.server start

it didn’t work…it took ages:

Starting MySQL
.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/stephen-mbp.local.pid).

Ya damn it!!!!

Sources