Authentication
This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.
| Property | Description |
| AuthScheme | Specifies the authentication scheme used to connect to the data source. This determines how the user or application credentials are validated. Choose an option supported by your MySQL server database. |
| Server | Specifies the host name or IP address of the MySQL server to connect to. This property supports both single-server and clustered environments through comma-separated values. |
| Port | Specifies the port number used to connect to the MySQL server. This property supports both single-node and clustered environments. For clusters, you may specify a comma-separated list of ports that correspond to each server in the Server property. |
| User | Specifies the authenticating user's user ID. |
| Password | Specifies the authenticating user's password. |
| Database | Specifies the name of the MySQL database to connect to by default. This determines the active schema used for queries unless explicitly overridden. |
| Domain | Specifies the Windows domain name to use when the AuthScheme is NTLM, which enables Windows Integrated Authentication using the NTLM protocol. This value is required if the user account belongs to a domain other than the local machine or default network domain. |
| NTLMVersion | Specifies the version of the NTLM protocol to use when authenticating with Windows credentials. This setting is only applicable when AuthScheme=NTLM. |
| IntegratedUser | Specifies the Windows user account to be used when authenticating with NTLM. This value is only applicable when AuthScheme=NTLM and is used to explicitly identify the integrated user for domain-based authentication. |
| UseSSL | This property determines whether Secure Sockets Layer (SSL) is enabled for communication. By default, SSL is set to 'false', meaning that communications are not encrypted unless explicitly enabled. |