Set up credentials
Gather these connection details from your MySQL database before connecting:1
Find your host and port
Locate your database host (the server address, for example
db.example.com or an IP) from your database provider or server config.
MySQL uses port 3306 by default.2
Identify your database name
Determine the database (schema) you want Adapt to query. You can list
databases with
SHOW DATABASES; if you are unsure.3
Create a read-only user (recommended)
For safety, create a dedicated user with read-only access and grant it
SELECT on the database you want Adapt to read, rather than using an admin
account. Note the user and password.If your database is behind a firewall or private network, make sure the host is
reachable and that any required IP addresses are allowlisted.
Connect to Adapt
1
Open Integrations
In Adapt, go to Settings > Integrations.
2
Find MySQL
Search for MySQL and select it from the catalog.
3
Start the connection
Click Connect to open the connection form.
4
Add your credentials
Enter the values you gathered above, then click Add connection:
You can rename the connection and choose whether it is shared with your
organization or kept personal to you.
5
Test the connection
Ask Adapt to list your tables or query your data.
Security
- Credentials are encrypted at rest with AES-256
- Use a dedicated user with read-only (
SELECT-only) privileges - Connect over SSL/TLS whenever your server supports it
- Restrict network access to your database and allowlist only trusted addresses
- Never share your credentials publicly or commit them to source control