问题:You must reset your password using ALTER USER statement before executing this statemen

这个主要是由一个参数控制的 default_password_lifetime
执行下面命令解决:

alter user user() identified by "123456";