MAC中 Mysql restart

sudo /usr/local/opt/mysql/support-files/mysql.server start          

sudo /usr/local/opt/mysql/support-files/mysql.server stop    

可能常遇到        

檔案使用權限的問題

sudo chown -R _mysql:_mysql /usr/local/var/mysql

sudo chmod -R 777 /usr/local/var/mysql/

----

在這個El Capitan 版本的話

start

sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

stop

sudo launchctl unload -F Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

---

source :

https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/

http://osxdaily.com/2014/11/26/start-stop-mysql-commands-mac-os-x/

http://stackoverflow.com/questions/9624774/after-mysql-install-via-brew-i-get-the-error-the-server-quit-without-updating