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?
A. mysql —protocol=PLAIN –uroot –p –h dbhost.example.com
B. INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
D. SET GLOBAL mysql_cleartext_passwords=1;
E. mysql —enable-cleartext-plugin –uroot –p –h dbhost.example.com
Answer: CE

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.
设置LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN环境变量的值，从一，Y，或Y。这支持the插件for all客户登录。
• The mysql, mysqladmin, and mysqlslap client programs support an —enable-cleartextplugin option that enables the plugin on a per-invocation basis.
这个MySQL，mysqladmin，mysqlcheck，mysqldump，MySQLShow，和mysqlslap客户端程序支持—enable-cleartext-plugin选项，使每一个调用基础插件。
• The mysql_options() C API function supports a MYSQL_ENABLE_CLEARTEXT_PLUGIN option that enables the plugin on a per-connection basis. Also, any program that uses libmysqlclient and reads option files can enable the plugin by including an enable-cleartext-plugin option in an option group read by the client library.
这个mysql_options()C API函数的支持mysql_enable_cleartext_plugin选项，使基于每一连接插件。另外，任何程序使用libmysqlclient读选项文件可以使插件包括使明文插件选择一个选项组的客户端库读取。http://www.cndba.cn/hbhe0316/article/22808http://www.cndba.cn/hbhe0316/article/22808http://www.cndba.cn/hbhe0316/article/22808http://www.cndba.cn/hbhe0316/article/22808http://www.cndba.cn/hbhe0316/article/22808

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL