Skip to content

MySQL

Overview

Connect MySQL to Trust3 to enable natural language queries across your relational database. Trust3 integrates seamlessly with MySQL databases using username and password authentication.

Prerequisites

Requirement Description
MySQL Server MySQL Server Host
Database Credentials Username and password with read permissions on target database

Quick Setup Process

  1. Navigate to Data Sources from the main menu → Click Add Data Source
  2. Select your data source type from the Source dropdown
  3. Enter a Connection Name (e.g., Sales Database)
  4. Configure the connection details
  5. Click Test Connection to validate
  6. Once successful, click Add Data Source to save

Finding Required Information

Finding Your MySQL Server Details

To find your MySQL connection information:

  1. Server Hostname/IP: Contact your database administrator or check your MySQL configuration
  2. Port: Default is 3306, but verify with your database administrator
  3. Username & Password: Credentials with read permissions on the target database

Configuration Details

Basic Information

Field Description Example
Connection Name * A unique identifier for this data source connection Production [Your Data Source]

Connection Settings

Field Description Example
Server Hostname * MySQL server hostname or IP address mysql.example.com or 192.168.1.100
Port * MySQL server port 3306 (default)
Username * MySQL username with read permissions analyst_user, readonly_user
Password * MySQL password -

Testing the Connection

After entering your connection details click Test Connection to validate the configuration

Connection Test Successful

Once the test is successful, you can proceed to save the data source.

Connection Test Failed

If the test fails, check the Troubleshooting section below for common issues and solutions.

Managing Data Sources

Update Connection

To update your data source connection:

  1. Navigate to Data Sources from the main menu
  2. Locate the connection you want to update
  3. Click the Actions button (three dots) → Edit
  4. Modify the connection fields as needed
  5. Click Test Connection to validate changes
  6. Click Update Data Source to save

Delete Connection

To delete an existing data source connection:

  1. Navigate to Data Sources from the main menu
  2. Locate the connection you want to delete
  3. Click the Actions button (three dots) → Delete
  4. Confirm the deletion in the dialog

Permanent Deletion Warning

Deleting a data source is permanent and cannot be undone. Any queries, reports, or integrations using this data source will stop working immediately. Make sure you want to proceed before confirming the deletion.

Troubleshooting

Common Issues

Issue Common Causes Solution
Connection timeout Firewall blocking connection, wrong hostname/IP Verify network connectivity and firewall rules allow Trust3 to connect
Authentication failed Wrong username/password Verify credentials and ensure user exists in MySQL
Database not found Incorrect database name or user lacks access Verify database name and check user permissions
Access denied User lacks necessary permissions

Additional Checks

  • Ensure MySQL server is running and accessible
  • Verify the port is correct (default: 3306)
  • Confirm username has appropriate permissions on the target database

Next Steps