mac 安装Mysql

1. 安装Mysql的步骤：

主要步骤参考：https://www.cnblogs.com/fooller/p/11121602.html

注：

使用下面两个命令均报错：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'indentified by '123'' at line 1

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
SET PASSWORD FOR 'root'@'localhost' PASSWORD = '你的新密码';

修改命令为：SET PASSWORD FOR 'root'@'localhost' = PASSWORD('你的新密码');

 

注：

按照上述链接的步骤设置环境变量之后，每次关掉终端，再次打开都需要重新source .bash_profile

解决方案：

1. vim ~/.zshrc，添加  export PATH=${PATH}:/usr/local/mysql/bin，并 保存

2. source ~/.zshrc 

3. 完美解决上述问题