content_image/821548.jpg content_image/821556.jpg content_image/821558.jpg
<img src='content_image/821548.jpg'>

Some authentication plugins implement proxy user mapping for themselves (for example, the PAM and Windows authentication plugins). Other authentication plugins do not support proxy users by default. Of these, some can request that the MySQL server itself map proxy users according to granted proxy privileges: mysql_native_password , sha256_password . 

If the check_proxy_users  system variable is enabled, the server performs proxy user mapping for any authentication plugins that make such a request. However, it may also be necessary to enable plugin- specific system variables to take advantage of server proxy user mapping support: 

•For the mysql_native_password  plugin, enable mysql_native_password_proxy_users . 

•For the sha256_password  plugin, enable sha256_password_proxy_users . 

For information about user proxying, see Section 6.2.18, “Proxy Users” . 

• collation_connection 

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

The collation of the connection character set. collation_connection  is important for comparisons of literal strings. For comparisons of strings with column values, collation_connection  does not matter because columns have their own collation, which has a higher collation precedence (see Section 10.8.4, “Collation Coercibility in Expressions” ). 

• collation_database 

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

