【MAC mysql 5.7安装】报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement解决方法
本人是MAC电脑,在mysql官网下载5.7版本后
输入PATH="$PATH":/usr/local/mysql/bin
mysql -u root -p登陆
再输入安装时自动生成的密码 ps:需要记录
成功登入,但是当输入show databases;
系统报错:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决方法:需要修改初始的密码,然后后才能执行语句,语句如下:
ALTER USER USER() IDENTIFIED BY ‘您的新密码’;
之后再输入show databases;
就可以成功运行啦