Prev Next Question 4/40 - 1Z0-888.v2019-10-20

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? (Choose two.)

Comments (The most recent comments are at the top.)

- Jul 12, 2020

Using SHA-256 Pluggable Authentication
To set up an account that uses the sha256_password plugin for SHA-256 password hashing, use the following statement, where password is the desired account password:

CREATE USER 'sha256user'@'localhost' IDENTIFIED WITH sha256_password BY 'password';

The server assigns the sha256_password plugin to the account and uses it to encrypt the password using SHA-256, storing those values in the plugin and authentication_string columns of the mysql.user system table.

The preceding instructions do not assume that sha256_password is the default authentication plugin. If sha256_password is the default authentication plugin, a simpler CREATE USER syntax can be used.

To start the server with the default authentication plugin set to sha256_password, put these lines in the server option file:

[mysqld]
default_authentication_plugin=sha256_password
That causes the sha256_password plugin to be used by default for new accounts. As a result, it is possible to create the account and set its password without naming the plugin explicitly:

CREATE USER 'sha256user'@'localhost' IDENTIFIED BY 'password';

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (40q)
Question 1: Which two options describe how MySQL Server allocates memory...
Question 2: Which MySQL utility program should you use to process and so...
Question 3: An admin attempts to enforce stronger security by using thes...
1 commentQuestion 4: You have the following in your my.cnf configuration file: [m...
Question 5: You are using the Performance Schema to investigate replicat...
Question 6: What is the best method for monitoring Group Replication con...
Question 7: Which two methods accurately monitor the size of your total ...
Question 8: Which three options are most likely to be changed for produc...
Question 9: Which three tasks are handled by the optimizer? (Choose thre...
Question 10: You have created a new user with this statement: CREATE USER...
Question 11: The following grants were executed: GRANT CREATE ROUTING ON ...
Question 12: You are contacted by a user who does not have permission to ...
Question 13: Which statement best describes the purpose of the InnoDB buf...
Question 14: Consider the CHECK TABLE command. In which two situations sh...
Question 15: Consider the index information for the dept_emp table in the...
Question 16: On a master server that is using statement-based replication...
Question 17: You have a MySQL replication setup and you intentionally sto...
Question 18: You are no longer able to log in to an existing MySQL Server...
Question 19: Consider the table people with this definition: (Exhibit) Th...
Question 20: To satisfy a security requirement, you have created or alter...
Question 21: You have a consistent InnoDB backup created with mysqldump, ...
Question 22: You have a server that has very limited memory but has a ver...
Question 23: You are setting up a new installation of MySQL Server 5.7 (a...
Question 24: Is it true that binary backups always take less space than t...
Question 25: Which statement is true about using Microsoft Windows Cluste...
Question 26: You enable binary logging on MySQL Server with the configura...
Question 27: Consider these global status variables: (Exhibit) Which two ...
Question 28: Examine the mydata table and SELECT statements: (Exhibit) Yo...
Question 29: Which three statements correctly describe MySQL InnoDB Clust...
Question 30: Which two statements are true about InnoDB auto-increment lo...
Question 31: The /myfolder/my.cnf file has option set: [mysqld] skip-log-...
Question 32: You inherited a busy InnoDB OLTP Instance with 100 schemas a...
Question 33: Force Majeure is a catastrophic failure on a major level of ...
Question 34: What two statements are true regarding FLUSH TABLES FOR EXPO...
Question 35: Consider: (Exhibit) Which statement best describes the meani...
Question 36: A MySQL server was initialized with separate UNDO tablespace...
Question 37: Which two statements are true regarding the creating of new ...
Question 38: Consider the key buffer in a MySQL server. Which two stateme...
Question 39: An existing master-slave setup is currently using a delayed ...
Question 40: Which two statements describe how InnoDB recovery works? (Ch...