content_image/678795.jpg content_image/678796.jpg
and transaction_read_only  system variables to correctly determine the session defaults. (To track these variables, list them in the value of the session_track_system_variables  system variable.) 

For more information about session state tracking, see Section 5.1.18, “Server Tracking of Client Session State Changes” . 

• sha256_password_auto_generate_rsa_keys 

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

The server uses this variable to determine whether to autogenerate RSA private/public key-pair files in the data directory if they do not already exist. 

At startup, the server automatically generates RSA private/public key-pair files in the data directory if all of these conditions are true: The sha256_password_auto_generate_rsa_keys  or caching_sha2_password_auto_generate_rsa_keys  system variable is enabled; no RSA options are specified; the RSA files are missing from the data directory. These key-pair files enable secure password exchange using RSA over unencrypted connections for accounts authenticated by the sha256_password  or caching_sha2_password  plugin; see Section 6.4.1.3, “SHA-256 Pluggable Authentication” , and Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . 

For more information about RSA file autogeneration, including file names and characteristics, see Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL” 

The auto_generate_certs  system variable is related but controls autogeneration of SSL certificate and key files needed for secure connections using SSL. 

• sha256_password_private_key_path 

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

