1Z0-888 Exam Dumps | You have the following in your my.cnf configuration file: [mysqld] default_authentication_plugin=sha256

<< Prev Question Next Question >>

Question 6/54

You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

A. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman';

B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';

C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';

D. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';

E. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman';

F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';

Question 6/54

LEAVE A REPLY

Download PDF File