- MySQL服务操作指令
# 启动
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
- 重启报错如下
ERROR! MySQL server PID file could not be found!
解决方案
# 查看mac下MySQL的进程(发现有多个与MySQL相关的操作)
ps -ax | grep mysql
# 杀掉所有与mysql相关的进程(注意: mac中默认未带xargs指令)
ps -ax | grep mysql | awk '{print $1}' | sudo xargs kill -9
# 启动mysql
sudo /usr/local/mysql/support-files/mysql.server start