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?
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.
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
D.
C
C is correct, my bad.
D is correct
http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
Existing accounts keep their original password format
C
Just tested with all kind of users (old & new) and the answer is C
Alternatively, start the server with the default authentication plugin set to sha256_password. For example, put these lines in the server option file:
[mysqld]default-authentication-plugin=sha256_password
That causes the sha256_password plugin to be used by default for new accounts and sets old_passwords to 2. As a result, it is possible to set the password at account-creation time with the CREATE USER statement.
Answer is C