试题详情

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?

AALTER USER USER() REQUERE CURRENT DEFAULT;

BALTER USER USER() EXPIRE PASSWORD NEVER;

CALTER USER USER() IDENTIFIED BY ‘password’;

DALTER USER USER() EXPIRE PASSWORD DEFAULT;