试题详情


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.