mysql - 如何停止mysqld

Question

要找出 mysqld 的启动命令(使用 mac)，我可以这样做:

ps aux|grep mysql

我得到以下输出，它允许我启动 mysql 服务器。

/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=...

如何找到从命令行停止 mysql 的必要命令？

Answer 1

试试:

/usr/local/mysql/bin/mysqladmin -u root -p shutdown 

或者:

sudo mysqld stop

或者:

sudo /usr/local/mysql/bin/mysqld stop

或者:

sudo mysql.server stop

如果您在 OSX 中安装 Launchctl，您可以尝试:

Mac 端口

sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql.plist
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql.plist

注意:重启后会持续存在。

自制

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

二进制安装程序

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

我发现在:https://stackoverflow.com/a/102094/58768