INSTALL MYSQL IN MAC

安装好MYSQL后,在System References中找到MYSQL,启动它。

启动之后在终端中输入添加MySQL路径的命令,把MYSQL路径添加到PATH中:

PATH="$PATH":/usr/local/mysql/bin

在终端登录到MySQL的命令如下:mysql -u root -p

当你执行任何语句的时候如show databases是会出现类似以下的错误,请用SET PASSWORD修改密码。

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> SET PASSWORD = PASSWORD('123456); 

原文地址:https://www.cnblogs.com/foxting/p/6195569.html