单选题

Choose the best answer.
MySQL is installed on a Linux server with this configuration: [mysqld]
User=mysql
Datadir=/data/mysql
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

ADefine CREATE USER ‘‘@‘%‘ IDENTIFIED WITH sha256_password in the MySQL instance.

BAdd default_authentication_plugin=sha256_password in the configuration file.

CAdd default_authentication_plugin=mysql_native_password in the configuration file.

DSet validate-user-plugins=caching_sha2_password in the configuration file.

查看答案

正确答案：A （备注：此答案有误）

相似试题

判断题

Employers often choose the best candidate.

答案解析
单选题

[音频]Listen to the dialogue and choose the best answer to the question you hear.( )

答案解析
单选题

Choose the best answer.Which statement is true about InnoDB persistent index statistics?

答案解析
单选题

Choose the best answer.How can mysqld_multi be configured to allow MySQL instances to use the same port number?

答案解析
单选题

Choose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

答案解析