Question 2
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 mysql client to connect to the server and send clear text passwords?
mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
SET GLOBAL mysql_cleartext_passwords=1;
mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com
Correct answer: DE
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html