刚安装完mysql后,执行任何sql命令都会提示以下错误:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
使用如下方法即可解决:
1. SET PASSWORD = PASSWORD('你的新密码');
2. ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
3. FLUSH PRIVILEGES;
完。