Macbook通过Homebrew安装mysql

Macbook如何和安装mysql呢？有两种方式，一种是直接在mysql官网下载dmg可执行文件(https://dev.mysql.com/downloads/mysql/)，直接双击就可以安装完成了。

mac版mysql下载地址

安装完成之后会在系统和偏好设置里面出现mysql的选项

mysql安装成功

打开mysql的安装选项，可以开启和关闭mysql服务，还可以设置开机启动

mysql控制台界面

而对于一名开发人员来讲，这么low的方式肯定不会采用啊，那么还有一种方式就是通过mac上强大的包管理工具Homebrew进行安装(关于Homebrew的介绍：https://brew.sh/index_zh-cn)

homebrew官网

首先要确认mac上已经安装了Homebrew

查看是否安装，打开terminal输入

brew

如果已经安装

homebrew已经安装

如果没有安装，打开terminal输入

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

确认安装成功

brew doctor

使用homebrew安装mysql,在terminal输入：

brew install mysql//默认安装最新版，也可以输入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 defaultTo connect run: mysql -uroot //root权限登录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"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

查看mysql安装位置

brew list mysql

在terminal中启动mysql服务：

brew services start mysql

homebrew mysql的配置

Remove anonymous users? [Y/n] Y //是否删除匿名用户Disallow root login remotely? [Y/n] Y //是否禁止远程登录Remove test database and access to it? [Y/n] Y //删除测试数据库，并登录Reload privilege tables now? [Y/n] Y//重新载入权限表

root登录

mysql -u root -p输入密码登录

进入mysql命令行,查看当前编码格式：

show variables like "%char%"

停掉mysql服务：

exitbrew services stop mysql

查看数据文件存储目录

mysqladmin -u root -p variables | grep datadir

如果之前安装了 MySQL 5.7,需要卸载

sudo rm /usr/local/mysqlsudo rm -rf /usr/local/mysql*sudo rm -rf /Library/StartupItems/MySQLCOMsudo rm -rf /Library/PreferencePanes/My*vim /etc/hostconfig (and removed the line MYSQLCOM=-YES-)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.*

如果之前没有安装过MySQL 5.7

brew install mysql@5.7 // 安装brew link --force mysql@5.7 // 链接brew services start mysql@5.7 // 启动服务echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc // 输出到环境变量

mac中mysql安装完成