如何在 Mac OS Lion 上从命令行启动 MySQL 服务器？

简单地：

mysql.server start

mysql.server stop

mysql.server restart

---

试试/usr/local/mysql/bin/mysqld_safe

例子：

shell> sudo /usr/local/mysql/bin/mysqld_safe
(Enter your password, if necessary)
(Press Control-Z)
shell> bg
(Press Control-D or enter "exit" to exit the shell)

您还可以将这些添加到您的 bash 启动脚本中：

export MYSQL_HOME=/usr/local/mysql
alias start_mysql='sudo $MYSQL_HOME/bin/mysqld_safe &'
alias stop_mysql='sudo $MYSQL_HOME/bin/mysqladmin shutdown'

---

我也喜欢别名...但是，我在启动 MySQLCOM 时遇到了问题...它默默地失败了...我的解决方法类似于其他... ~/.bash_aliases

alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'
alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop' 

---

正如 this 有用的文章所述：在 OS X 上从命令行启动/停止 MySQL：

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

在 Linux 上从命令行启动/停止：

/etc/init.d/mysqld start 
/etc/init.d/mysqld stop 
/etc/init.d/mysqld restart 

一些 Linux 版本也提供 service 命令

# service mysqld start 
# service mysqld stop 
# service mysqld restart

或者

 # service mysql start 
 # service mysql stop 
 # service mysql restart 

---

如果您使用自制软件安装它，则二进制文件将类似于

/usr/local/Cellar/mysql/5.6.10/bin/mysqld

这意味着你可以开始

/usr/local/Cellar/mysql/5.6.10/support-files/mysql.server start

并停止它

/usr/local/Cellar/mysql/5.6.10/support-files/mysql.server stop

编辑：正如 Jacob Raccuia 提到的，确保将适当版本的 MySQL 放在路径中。

---

也许你的 mysql-server 没有启动。

你可以试试

/usr/local/bin/mysql.server start

---

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

在 .bash_profile 中创建别名

alias start_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM start"
alias stop_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM stop"

如果您尝试以 root 身份运行，请使用以下安全模式

sudo ./bin/mysqld_safe

如果您仍然遇到问题，建议阅读：mysql5.58 unstart server in mac os 10.6.5

---

对我来说，这个解决方案适用于 mac Sierra OS：

sudo /usr/local/bin/mysql.server start
Starting MySQL
SUCCESS!

---

我的 MySQL 是通过 OS X ElCaptain 上的自制软件安装的。什么修复了它正在运行

brew doctor

这表明我运行

sudo chown -R $(whoami):admin /usr/local

然后：

brew update
mysql.server start

mysql现在正在运行

---

如果它与自制软件一起安装，请尝试在终端中输入 mysql.server 就可以了。 AFAIK 它的可执行文件将位于 /usr/local/bin/mysql.server 下。

如果没有，您可以随时运行“locate mysql.server”，它会告诉您在哪里可以找到此类文件。

---

如果您通过 Homebrew 安装了 MySQL，这些命令将帮助您：

# For starting
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

# For stoping
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

---

MySql 服务器启动错误'服务器退出但没有更新 PID 文件'

如果您从自制软件安装了 mysql

从 mac 的首选项关闭 mysql 服务器

ps ax | grep mysql

#kill all the mysql process running
sudo kill -9 pid

which mysql
/usr/local/bin/mysql
Admins-MacBook-Pro:bin username$ sudo mysql.server start

Starting MySQL
. SUCCESS! 

Admins-MacBook-Pro:bin username$ which mysql

/usr/local/bin/mysql

Admins-MacBook-Pro:bin username$ ps ax | grep mysql

54916 s005  S      0:00.02 /bin/sh 
/usr/local/Cellar/mysql@5.7/5.7.27_1/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/Admins-MacBook-Pro.local.pid
55012 s005  S      0:00.40 /usr/local/Cellar/mysql@5.7/5.7.27_1/bin/mysqld --basedir=/usr/local/Cellar/mysql@5.7/5.7.27_1 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql@5.7/5.7.27_1/lib/plugin --user=mysql --log-error=Admins-MacBook-Pro.local.err --pid-file=/usr/local/var/mysql/Admins-MacBook-Pro.local.pid
55081 s005  S+     0:00.00 grep mysql

---

在 mac Big Sur 和 MySQL 5.7 上，我需要停止/开始：

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

和

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

此答案来自 https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/

---

111028 16:57:43 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

你为你的mysql安装设置了root密码吗？这与您的 sudo root 密码不同。试试/usr/local/mysql/bin/mysql_secure_installation

---