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

error:

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

spl:

set password= password('123456');
flush privileges;