To restart, start or stop MySQL server from the command line, type the following at the shell prompt…
On OS X to start/stop/restart MySQL pre 5.7 from the command line:
sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart
On OS X Yosemite/El Capitan to start/stop/restart MySQL post 5.7 from the command line:
sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist