Authentication Plugins 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” ): [Note] Plugin test_plugin_server reported: ’successfully authenticated user  testpassword ’ 6.4.1.11 Pluggable Authentication System Variables 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 Table 6.23 Authentication Plugin System Variable Summary Name Cmd-Line Option File System Var Status Var Var Scope Dynamic authentication_ldap_sasl_auth_method_name Yes Yes Yes Global Yes authentication_ldap_sasl_bind_base_dn Yes Yes Yes Global Yes authentication_ldap_sasl_bind_root_dn Yes Yes Yes Global Yes authentication_ldap_sasl_bind_root_pwd Yes Yes Yes Global Yes authentication_ldap_sasl_ca_path Yes Yes Yes Global Yes authentication_ldap_sasl_group_search_attr Yes Yes Yes Global Yes authentication_ldap_sasl_group_search_filter Yes Yes Yes Global Yes authentication_ldap_sasl_init_pool_size Yes Yes Yes Global Yes authentication_ldap_sasl_log_status Yes Yes Yes Global Yes authentication_ldap_sasl_max_pool_size Yes Yes Yes Global Yes authentication_ldap_sasl_referral Yes Yes Yes Global Yes authentication_ldap_sasl_server_host Yes Yes Yes Global Yes authentication_ldap_sasl_server_port Yes Yes Yes Global Yes authentication_ldap_sasl_tls Yes Yes Yes Global Yes authentication_ldap_sasl_user_search_attr Yes Yes Yes Global Yes authentication_ldap_simple_auth_method_name Yes Yes Yes Global Yes authentication_ldap_simple_bind_base_dn Yes Yes Yes Global Yes authentication_ldap_simple_bind_root_dn Yes Yes Yes Global Yes authentication_ldap_simple_bind_root_pwd Yes Yes Yes Global Yes authentication_ldap_simple_ca_path Yes Yes Yes Global Yes 1360