content_image/672209.jpg content_image/672219.jpg content_image/672220.jpg
<img src='content_image/672209.jpg'>

This variable is available only if the authentication_windows  Windows authentication plugin is enabled. See Section 6.4.1.6, “Windows Pluggable Authentication” . 

A client that authenticates using the InitSecurityContext()  function should provide a string identifying the service to which it connects ( targetName ). MySQL uses the principal name (UPN) of the account under which the server is running. The UPN has the form user_id @ computer_name  and need not be registered anywhere to be used. This UPN is sent by the server at the beginning of authentication handshake. 

This variable controls whether the server sends the UPN in the initial challenge. By default, the variable is enabled. For security reasons, it can be disabled to avoid sending the server’s account name to a client as cleartext. If the variable is disabled, the server always sends a 0x00  byte in the first challenge, the client does not specify targetName , and as a result, NTLM authentication is used. 

If the server fails to obtain its UPN (which happens primarily in environments that do not support Kerberos authentication), the UPN is not sent by the server and NTLM authentication is used. 

• autocommit 

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

The autocommit mode. If set to 1, all changes to a table take effect immediately. If set to 0, you must use COMMIT  to accept a transaction or ROLLBACK  to cancel it. If autocommit  is 0 and you change it to 1, MySQL performs an automatic COMMIT  of any open transaction. Another way to begin a transaction is to use a START TRANSACTION  or BEGIN  statement. See Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements” . 

By default, client connections begin with autocommit  set to 1. To cause clients to begin with a default of 0, set the global autocommit  value by starting the server with the --autocommit=0  option. To set the variable using an option file, include these lines: 

[mysqld] autocommit=0 

• automatic_sp_privileges 

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

