Client Authentication Failure When TPC-C Is Used to Load Data

Symptom

When TPC-C is used to load data, the message "client does not support authentication protocal requested by server" is displayed.

Key Process and Cause Analysis

A possible cause is that the version of the authentication plugin required by the MySQL server does not match that of the client.

Conclusion and Solution

Restore the encryption rule for the MySQL user login password to mysql_native_password and reset the password.

1. Run the following statements in the database to change the user password and update the privilege table:

   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
   ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
   FLUSH PRIVILEGES;

2. Run the data loading command again.