Examine this command and response:
Mysql> select 1;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement befor executing this statement.
Which option will fix this problem?
Mysql> select 1;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement befor executing this statement.
Which option will fix this problem?
AALTER USER USER() REQUERE CURRENT DEFAULT;
BALTER USER USER() EXPIRE PASSWORD NEVER;
CALTER USER USER() IDENTIFIED BY ‘password’;
DALTER USER USER() EXPIRE PASSWORD DEFAULT;