为什么用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, 测试一下你设置的密码吧!
