MySQL

The MySQL Database config is the way Ardent gains the ability to work with data in your MySQL Database. It is designed to take in basic auth credentials and use that to automatically understand the data within your database and tables so you can perform operations on it.

Usage

To use the MySQL integration with Ardent, you need to provide the necessary configuration details. Here's an example of how to set up the MySQL config:

1. Find the Configs Section: Go to the configs section in the app

   

2. Add a Config: Click Add New Config

3. Select Config: Select the MySQL config

4. Enter Values and Save Config: Configs will not save until you hit "save". Enter the necessary information for your config and hit Save
   • Host: Your MySQL server hostname
   • Port: The port number (default: 3306)
   • Username: Your MySQL username
   • Password: Your MySQL password
   • Databases: Add any databases you want to work with

Connection Details

The MySQL config requires:

• Host: The hostname where your MySQL server is running
• Port: The port number MySQL is listening on (default: 3306)
• Username: Your MySQL username
• Password: Your MySQL password
• Databases: The specific databases you want to work with

You can add multiple databases to a single configuration by using the "Add Database" button.

Note on Connection Configurations

MySQL requires:

• A running MySQL server accessible from your network
• Valid authentication credentials
• Proper database permissions
• Valid database names that exist in your MySQL instance
• Appropriate read/write permissions for the authenticated user
• Important: The host cannot be localhost. Please use the actual endpoint for the host.

For more information about MySQL connection configuration, please refer to the MySQL documentation.