mysql 修改密码遇到的问题
错误一:在liunx 环境安装mysql 修改密码时:遇到 ERROR 1046 (3D000): No database selected错误
原因:必须先选择 mysql 自身的数据库:
use mysql;
## 错误二:修改密码时又遇到: ERROR 1054 (42S22): Unknown column ‘password’ in 'field list’
解决方案:
update mysql.user set authentication_string=password('123456') where user='root';
命令立即执行生效:flush privileges;
quit;
错误三:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before e