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 all connect via the secure sha256_password algorithm without any configuration
change.
B.
They are not affected by this configuration change.
C.
They will have to change their password the next time they login to the server.
D.
They will have their passwords updated on start-up to sha256_password format.
B
A
http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
Incorrect Kenny. New users yes, they can use the sha256 algorithm, but existing users are not affected.
For me also is B, because from the link says “That causes the sha256_password plugin to be used by default for new accounts.” that will be for new users, and the question is “What effect will the NEW configuration have in EXISTING ACCOUNTS?”, so nothing.
one more “Accounts in the mysql.user table that use SHA-256 passwords can be identified as rows with ‘sha256_password’ in the plugin column and a SHA-256 password hash in the authentication_string column.”
B