A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:
The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
[mysqld]
default-authentication-plgin=sha256_passwordhttp://www.cndba.cn/hbhe0316/article/22792http://www.cndba.cn/hbhe0316/article/22792

A. They are not affected by this configuration change.
B. They all connect via the secure sha256_password algorithm without any configuration change.
C. They will have their passwords updated on start-up to sha256_password format.
D. They will have to change their password the next time they login to the server.
Answer: A
MySQL已经运行某业务6个月了，重启也不会有报错，现在在my.cnf中增加如下配置：
default-authentication-plgin=sha256_password
那么会对现有数据库账号产生什么影响？
A． 没影响
B． 他们的连接都会使用sha256_password密码方式
C． 他们的密码会被更小为sha256_password格式
D． 下次登录时他们必须修改密码
sha256_password插件是由新帐户的默认使用。http://www.cndba.cn/hbhe0316/article/22792http://www.cndba.cn/hbhe0316/article/22792

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL