mac下安装mysql

一直用的docker的mysql，今天尝试在mac下安装mysql，还是踩了一些坑。

安装

brew install mysql@5.7

重置密码

• brew services stop mysql@5.7
• cd /usr/local/opt/mysql@5.7/bin
• /mysqld_safe --skip-grant-tables
• Command+N新开窗口
• mysql -u root
• use mysql;
• update user set authentication_string = password('123456') where user='root';
• flush privileges;
• quit
• brew services start mysql@5.7

参考文档

https://blog.youkuaiyun.com/ttdevs/article/details/52416114

https://www.cnblogs.com/gumuzi/p/5711495.html