数据库安装后执行命令ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决办法：
mysql> SET PASSWORD = PASSWORD('password123!');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
本文共 280 字，大约阅读时间需要 1 分钟。
数据库安装后执行命令ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决办法：
mysql> SET PASSWORD = PASSWORD('password123!');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
转载于:https://blog.51cto.com/xiaoxiaozhou/2157198