Mac用brew安装mysql

---

一、通过brew命令安装

安装brew

brew类似一个应用商店，我们可以用它安装很多软件
终端执行命令（两种都可以试试）：
1./usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
2.ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

查看brew安装成功

安装mysql

1. 终端输入命令：brew insatll mysql
2. mysql 说明了mysql的密码以及启动方式

==> mysql
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

To restart mysql after an upgrade:
  brew services restart mysql
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir=/opt/homebrew/var/mysql

3. 启动mysql：可以使用命令查看提示，brew info mysql，根据提示，有两种启动方式：brew services start mysql，或者 mysql.server start。

二、启动mysql并设置密码

1.启动mysql

输入：mysql.server start，启动，提示成功

DIDI-C02G17HXQ05P:~ didi$ mysql.server start
Starting MySQL
 SUCCESS!

2.设置密码

输入：mysql_secure_installation，设置密码，此处步骤为操作实例

总结：
1.启动服务
2.执行安全配置
3.删除匿名帐号，放开远程连接，删除test测试库，重新加载权限表
4.测试连接

//输入命令
DIDI-C02G17HXQ05P:~ didi$ mysql_secure_installation

Securing the MySQL server deployment