Data Connectors
MySQL
For connecting your MySQL database with OmniAI, please use the following configuration parameters:
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. |
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.