Data Connectors
MySQL
For connecting your MySQL database with OmniAI, please use the following configuration parameters:
Ensure that your MySQL instance is configured to accept connections from OmniAI and that the user account has appropriate permissions set up for the operations you intend to perform.
Configuration Options
Parameter | Description |
|---|---|
Host | The hostname or IP address of the MySQL server. |
Port | The port number on which the MySQL server is listening (default is 3306). |
Database | The name of the MySQL database you want to connect to. |
Username | Your MySQL database user login name. |
Password | The password associated with your MySQL database user. |
SSL Mode | (Optional) The desired level of SSL certificate verification (e.g., require, verify-full, disable). Recommended for secure connections. |