<< Prev Question Next Question >>

Question 19/49

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

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

mrson92 - Jul 12, 2020

To make inadvertent use of the mysql_clear_password plugin less likely, MySQL clients must explicitly enable it. This can be done in several ways:

Set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN environment variable to a value that begins with 1, Y, or y. This enables the plugin for all client connections.

The mysql, mysqladmin, and mysqlslap client programs (also mysqlcheck, mysqldump, and mysqlshow for MySQL 5.7.10 and later) support an --enable-cleartext-plugin option that enables the plugin on a per-invocation basis.

LEAVE A REPLY

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

Question List (49q)
1 commentQuestion 1: You have created a new user with this statement: CREATE USER...
Question 2: You are using the Performance Schema to investigate replicat...
Question 3: You inherited a busy InnoDB OLTP Instance with 100 schemas a...
Question 4: An administrator installs MySQL to run under a mysqlOS accou...
Question 5: To satisfy a security requirement, you have created or alter...
Question 6: Consider these global status variables: (Exhibit) Which two ...
Question 7: Which three options are most likely to be changed for produc...
Question 8: These details are shown when logged in to an account: (Exhib...
Question 9: Suppose you are adding rows to a MyISAM table and the --data...
Question 10: You are no longer able to log in to an existing MySQL Server...
Question 11: A MySQL replication slave is set up as follows: Uses all Inn...
1 commentQuestion 12: The MySQL error log shows: InnoDB: Warning: a long semaphore...
Question 13: You have the following in your my.cnf configuration file: [ ...
Question 14: Host slave1 has ip address 192.0.2.10. Host slave2 has ip ad...
Question 15: The MySQL installation includes the mysql_config_editorutili...
Question 16: Which two statements are true regarding the creating of new ...
Question 17: Consider the join_buffer_sizeparameter in MySQL Server. Whic...
2 commentQuestion 18: Consider the key buffer in a MySQL server. Which two stateme...
1 commentQuestion 19: Due to an authentication plug-in that is used on the server,...
Question 20: After analysis on the slow query log on a high-end OLTP serv...
Question 21: Consider the table people with the definition: (Exhibit) The...
Question 22: A crucial database, 'db_prod', just disappeared from your pr...
1 commentQuestion 23: Consider that local disk files are accessible via MySQL with...
Question 24: There are multiple instances of MySQL Server running on a si...
1 commentQuestion 25: old_alter_tableis disabled as shown. mysql&gt; SELECT @@old_...
Question 26: A MySQL database uses all InnoDB tables and is configured as...
Question 27: What is the best method for monitoring Group Replication con...
Question 28: You are setting up a new installation of MySQL Server 5.7 (a...
1 commentQuestion 29: Which two statements describe how InnoDB recovery works? (Ch...
Question 30: Which are three facts about backups with mysqldump? (Choose ...
Question 31: The following grants were executed: GRANT CREATE ROUTING ON ...
Question 32: Which two statements are true about InnoDB auto-increment lo...
1 commentQuestion 33: Which three allocate memory per thread in MySQL? (Choose thr...
Question 34: You will configure a MySQL Server to act as a replication ma...
Question 35: You have installed MySQL Server for the first time on your s...
Question 36: Which three statements correctly describe MySQL InnoDB Clust...
Question 37: You created a backup of the worlddatabase with this command:...
Question 38: You want to create a temporary table named OLD_INVENTORYin t...
Question 39: You have a MySQL instance with the following variables in th...
Question 40: What is the order of tables shown in an EXPLAINoutput?...
Question 41: How does the InnoDB storage engine handle deadlocks when the...
Question 42: Force Majeure is a catastrophic failure on a major level of ...
1 commentQuestion 43: Which three tasks are handled by the optimizer? (Choose thre...
Question 44: An admin attempts to enforce stronger security by using thes...
1 commentQuestion 45: A master-slave replication setup has the slave showing this ...
Question 46: A single InnoDB table has been dropped by accident. You are ...
Question 47: When you examine a new MySQL installation with default confi...
1 commentQuestion 48: A MySQL server was initialized with separate UNDO tablespace...
Question 49: A MySQL Server has been running an existing application succ...