Oracle Database MySQL 5.6 Database Administrator — Question 3

A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?

Answer options

• A. They will have their passwords updated on start-up to sha256_password format.
• B. They will have to change their password the next time they login to the server.
• C. They are not affected by this configuration change.
• D. They all connect via the secure sha256_password algorithm without any configuration change.

Correct answer: D

Explanation

The correct answer is D because existing accounts will automatically use the sha256_password authentication method without requiring any action from the users. Options A and B suggest that users need to change or update their passwords, which is not necessary in this scenario. Option C is incorrect as the configuration change does indeed affect how users authenticate.