content_image/818047.jpg
Then provide the --user  and --password  options for that account when you connect to the server. For example: 

shell> mysql --user=testuser --password Enter password: testpassword 

The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string  column of the account row in the mysql.user  system table. If the two values match, the plugin returns the authentication_string  value as the new effective user ID. 

You can look in the server error log for a message indicating whether authentication succeeded (notice that the password is reported as the “user” ): 

## 6.4.1.11 Pluggable Authentication System Variables 

[Note] Plugin test_plugin_server reported: ’successfully authenticated user testpassword ’ 

These variables are unavailable unless the appropriate server-side plugin is installed: 

• authentication_ldap_sasl  for system variables with names of the form authentication_ldap_sasl_ xxx 

• authentication_ldap_simple  for system variables with names of the form authentication_ldap_simple_ xxx 

<img src='content_image/818047.jpg'>

