MySQL - 通过Homebrew安装与启动配置

准备

将Homebrew设置使用代理，很多时候即使使用了国内镜像源，其有些内部依赖下载还是使用的境外下载链接，不但很难下载更会扰乱心智，再次强烈建议将Homebrew使用全局代理，以绝后患

注意：此操作会同时代理git，若因某种情况无法使用代理时，可以先注释掉ALL_PROXY，之后再解掉注释

echo 'export all_proxy=socks5://127.0.0.1:1086' >> ~/.bash_profile
source ~/.bash_profile

重启终端

安装MySQL 5.7

命令

使用Homebrew进行安装MySQL 5.7

brew install mysql@5.7

安装成功提示

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"' >> ~/.bash_profile

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"


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: 318 files, 232.3MB, built in 18 minutes 50 seconds

配置

将MySQL的bin目录加入到PATH路径中

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile

编辑~/.bash_profile文件，加入

export LDFLAGS="-L/usr/local/opt/mysql@5.7/lib"
export CPPFLAGS="-I/usr/local/opt/mysql@5.7/include"

最后source

source ~/.bash_profile

启动

以后台服务形式启动MySQL

brew services start mysql@5.7

以前台形式启动MySQL，关闭终端则停止MySQL服务

/usr/local/opt/mysql@5.7/bin/mysql.server start

登陆

无密码登陆

mysql -uroot

此时可以无密码登陆到MySQL数据库中

设置密码

mysqladmin -uroot password 123456

将root用户的密码设置为123456

密码登陆

mysql -uroot -p

然后输入密码登陆

或者

mysql -uroot -p123456