MySQL 8.0 Database Administrator — Question 87

Which two methods allow a DBA to reset a user's password? (Choose two.)

Answer options

• A. ALTER USER statement
• B. mysql_secure_installation utility
• C. SET PASSWORD statement
• D. mysqladmin client program
• E. GRANT statement

Correct answer: A, C

Explanation

The ALTER USER statement and SET PASSWORD statement are both valid SQL commands that allow a DBA to change a user's password directly in the database. The other options, such as mysql_secure_installation and GRANT statement, do not specifically provide functionality for resetting passwords.