MySQL

For MySQL:

New Server Connection panel for a MySQL server connection

Providing the basic connection information

1. In the Host field, provide the hostname for the server.

2. In the Port field, provide the port to connect through.

3. From the SSL/TLS dropdown list, select whether to enable or require Secure Socket Layer (SSL) or Transport Layer Security (TLS).

   If you select Verify CA, you must add the required certificate to the account certificates list.

Configuring the authentication

Selecting the authentication method

From the Authentication dropdown list, select the type of authentication to use.

The options are:

• Username & Password. This is the default.

• AWS IAM Role. To use this option, you must first configure the available AWS roles for the workspace.

• Azure AD Service Principal. To use this option, you must first configure the available Azure service principals for the workspace.

Providing a username and password

For username and password authentication:

1. In the Username field, provide the username to use to make the connection.

2. In the Password field, provide the password.

Providing an AWS role

For AWS IAM role authentication:

1. In the Username field, provide the username to use to make the connection.

2. From the AWS Role dropdown, select the role to use.

Providing an Azure service principal

For Azure AD service principal authentication:

1. In the Username field, provide the username for the Microsoft Entra user to use to make the connection. The user must be mapped to the service principal that you select.

2. From the Azure Service Principal dropdown, select the service principal to use.