What Do I Do If the Error Message "plugin not enabled" Is Displayed When the MySQL Client Is Used to Connect to the Doris Database?

Symptom

The following error message is displayed when the MySQL client is used to connect to the Doris database:

ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled

Cause Analysis

The mysql_clear_password plug-in is disabled.

Procedure

• When you use the MySQL client to connect to the Doris database, run the following command with --enable-cleartext-plugin added:

  mysql --enable-cleartext-plugin -uDatabase login user -pDatabase login user password -PDatabase connection port -hDoris FE instance IP address

• Run the following command on the node where the MySQL client is installed to enable the mysql_clear_password plug-in, and then reconnect to Doris:

  export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1