Mac下使用brew安装MySQL

为什么用brew安装呢?
方便, 不用去官网找MySQL的各种版本, 而且各种版本会把你绕的挺晕的.

首先你要有个brew

brew install 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

A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start

我本来想用mysql_secure_installation设置密码的, 但是发生错误, 只能换一种方式设置密码.

首先启动MySQL服务

brew services start mysql
这种是后台启动方式, 方便你下次使用MySQL服务的时候, 直接使用

然后登录MySQL

mysql -u root

MySQL5.7以后会出现输入update mysql.user set password=password('root') where user='root'时提示ERROR 1054 (42S22): Unknown column 'password' in 'field list'，原来是mysql数据库下已经没有password这个字段了，password字段改成了authentication_string.

接下来更新root密码

update mysql.user set authentication_string=password('root') where user='root' ;

最会别忘了刷新权限

flush privileges;

👌 现在退出MySQL, 测试一下你设置的密码吧!