mac停止mysql_在Mac OS上如何停止MySQL？

I installed MySQL via MacPorts. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)?

解决方案

There are different cases depending on whether you installed MySQL with the official binary installer, using MacPorts, or using Homebrew:

MacPorts

sudo port load mysql57-server

sudo port unload mysql57-server

Note: this is persistent after a reboot.

Homebrew

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Binary installer

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart