Mac使用 brew 安装mysql5.7

最新推荐文章于 2025-10-10 17:35:56 发布

原创最新推荐文章于 2025-10-10 17:35:56 发布 · 1.1k 阅读

2 ·

CC 4.0 BY-SA版权

homebrew 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了在Mac上如何通过brew清除旧版MySQL并安装MySQL5.7的详细步骤，包括停止相关进程、执行安装命令、配置环境变量、启动MySQL以及解决启动时遇到的问题。

1.清除之前安装的MySQL

先停止所有mysql有关进程

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*

如果brew之前安装过也要卸载

2. 安装MySQL

执行brew install mysql@5.7,
然后出现

➜  ~ brew install mysql@5.7
==> Downloading https://homebrew.bintray.com/bottles/mysql@5.7-5.7.29.catalina.bottle.tar.gz
Already downloaded: /Users/duheyuan/Library/Caches/Homebrew/downloads/9d9f10181613ae442dfb00f24c9b74b30752d8b19c25d8d4c98889597773730d--mysql@5.7-5.7.29.catalina.bottle.tar.gz
==> Pouring mysql@5.7-5.7.29.catalina.bottle.tar.gz
==> /usr/local/Cellar/mysql@5.7/5.7.29/bin/mysqld --initialize-insecure --user=duheyuan --basedir=/u
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -uroot

mysql@5.7 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.

If you need to have mysql@5.7 first in your PATH run:
  echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql@5.7 you may need to set:
  export LDFLAGS="-L/usr/local/opt/mysql@5.7/lib"
  export CPPFLAGS="-I/usr/local/opt/mysql@5.7/include"

For pkg-config to find mysql@5.7 you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/mysql@5.7/lib/pkgconfig"


To have launchd start mysql@5.7 now and restart at login:
  brew services start mysql@5.7
Or, if you don't want/need a background service you can just run:
  /usr/local/opt/mysql@5.7/bin/mysql.server start
==> Summary
🍺  /usr/local/Cellar/mysql@5.7/5.7.29: 319 files, 232.3MB

安装完成,接下来我们要根据提示运行
echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc, 把MySQL路径写到zshrc里,没装zsh的写入到bash_profile.

然后来一个灵魂一击,source ~/.zshrc or source ~/.bash_profile

启动MySQL

brew services start mysql@5.7or /usr/local/opt/mysql@5.7/bin/mysql.server start.
要想直接使用mysql.server start需要配置zshrc文件.
vim ~/.zshrc打开后添加alias mysql="/usr/local/opt/mysql@5.7/bin/mysql"
然后再来一遍source ~/.zshrc

搞定

最后记一下安装过程中出现的问题

在启动时候出现了一个错误
ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro.local.pid).
找了很多帖子尝试发现都不行，因为里面是本地的数据库文件，平时开发用的线上数据库所以干脆放弃删除掉了，然后重新安装数据库，okay了