# MySQL

### Connect MySQL to Actian AI Analyst

To connect your MySQL database to Actian AI Analyst, follow these steps:

* Create a read-only user account.
* Grant access to the necessary databases and tables.
* Set up the connection in the Actian AI Analyst interface.

⚠️ Actian AI Analyst's agents only run **read-only queries** on your data. No write or administrative privileges are required.

***

#### 1. Create a Read-Only User in MySQL

Create a dedicated MySQL user that Actian AI Analyst will use to query your data. This user should be restricted to only what's necessary for analysis.

```sql
-- Replace with your secure username and password
CREATE USER 'analyst_user'@'%' IDENTIFIED BY 'your_secure_password';

-- Grant usage access (no database access yet)
GRANT USAGE ON *.* TO 'analyst_user'@'%';
```

✅ Use a strong password and avoid reusing credentials across systems.

***

#### 2. Grant Read-Only Access to Data

Decide which databases and tables Actian AI Analyst should access, typically your reporting or analytics schemas.

```sql
-- Replace `your_database` and `your_table` with actual names
GRANT SELECT ON your_database.* TO 'analyst_user'@'%';
```

🔐 This provides Actian AI Analyst read-only access to all tables in the specified database. If you want finer control, you can grant access on a per-table basis:

```sql
 SELECT ON your_database.sales_data TO 'analyst_user'@'%';
GRANT SELECT ON your_database.customer_summary TO 'analyst_user'@'%';
```

✅ For multi-schema environments, repeat the grant process for each schema or table Actian AI Analyst needs.

***

#### 3. Optional Configuration (Recommended)

* **Restrict Host Access:** For added security, limit login access to specific IP ranges if your MySQL server supports it.
* **Limit Resource Usage:** You can apply resource limits (like `MAX_QUERIES_PER_HOUR`) on the user if needed.

***

#### 4. Set Up the Connection in Actian AI Analyst

1. Click **Connections → Plus button → Select MySQL**.
2. Fill in the following details:
   * **Host:** your MySQL server hostname or IP address
   * **Port:** default is `3306` unless changed
   * **Database:** the default database Actian AI Analyst should use
   * **Username:** `analyst_user`
   * **Password:** the secure password you set
   * **SSL:** enable if your MySQL instance requires encrypted connections
3. Test the connection and click **Save**.

📂 Actian AI Analyst only queries the data the user can see—if the user doesn't have access, Actian AI Analyst won't either.

***

#### That's It!

Actian AI Analyst is now connected to MySQL. You can start asking questions in natural language—no dashboards, no SQL—just insights.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.wobby.ai/connections/connect-a-data-source/mysql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.