Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 123

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

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

Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

Add default_authentication_plugin=mysql_native_password in the configuration file.

Add default_authentication_plugin=sha256_password in the configuration file.

Correct Answer: D

To set the default authentication to SHA-256 hashing for user account passwords, you need to add default_authentication_plugin=sha256_password in the MySQL configuration file. This configuration changes the default authentication plugin to sha256_password, ensuring that newly created user accounts will use SHA-256 hashing.

Discussion

marklvOption: D

D is it