MySQL 8.0 Database Administrator — Question 25

Which two MySQL Server accounts are locked by default? (Choose two.)

Answer options

• A. any user set as DEFINER for stored programs
• B. any internal system accounts
• C. any new ROLE accounts
• D. any user created without a password
• E. any user created with a username, but missing the host name

Correct answer: A, B

Explanation

The correct answers are A and B because any user designated as DEFINER for stored programs and all internal system accounts are locked by default in MySQL Server for security reasons. The other options, including new ROLE accounts, users without passwords, and users missing hostnames, do not have this default locking behavior.