如何解决mysql创建表的时报错问题: You must reset your password using ALTER USER statement before executing this st

1、报错

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

2、连接数据库

3、修改账号和密码：

alter user 'root'@'localhost' identified by '123456';

4、刷新重置

flush privileges;

5、显示账号