准备
将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