MySQL DB Adapter

Connection Requirements

1

IP

MySQL Server IP Address.

2

Port

Port number (optional, default: 3306).

3

Domain

Domain FQDN.

4

Database

Base database.

5

Username

Value provided username in MySQL server.

To create a User:

• Open MySQL Server Management Studio.

• Go to Management > Users and Privileges. Select the user you want to grant permissions

• Click Schema Privileges.

• Click Add Entry, select the database and click OK

• Check SELECT, under the Object Rights and click Apply and confirm.

• Login to the database with this user once to avoid an error.

🔵 "Select" The user must have privilege.

6

Password

The Password of the provided username.

7

View Name

The view name of SQL Server. (required).

8

Custom Query

The custom query field for SQL Server. (optional).

⚠️ Attention Please perform a connection test to ensure there is a valid connection to the host. When the discovery operation is finalized, you will be able to see the details on the Assets page.