> ## Documentation Index
> Fetch the complete documentation index at: https://julius.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Setup MySQL
> Learn how to securely connect Julius to your MySQL database to analyze your data directly without uploading files.
## Getting Started
Julius connects directly to your MySQL database, allowing you to analyze your data using natural language; no SQL knowledge required.
Navigate to the **Data Connectors** page and click **"Create new Data Connector"**, then select **MySQL**.
***
## Connection Setup
### Required Fields
All fields marked with an asterisk (\*) are required.
A friendly name to identify this connection in Julius.
**Example:** "Production DB" or "Sales Database"
The server address where your MySQL database is hosted.
**Format:** IP address (`192.168.1.100`) or domain (`db.mycompany.com`)
**Cloud databases:** Provided by AWS RDS, Google Cloud SQL, etc.
The network port for MySQL connections.
**Default:** `3306`
**Note:** Only change if using a custom port
The specific database name to analyze.
**Example:** `sales_data`, `customers`, `analytics`
Your MySQL database username with read permissions.
Create a dedicated read-only user for Julius
Password for your MySQL user account.
**Security:** Encrypted in transit and at rest
***
## Network Configuration
1. Click **"Add Connection"** to test your configuration
2. Julius validates your credentials and network access
3. If successful, your connector is ready to use!
* ✓ Host and port are correct
* ✓ Database allows external connections
* ✓ Username and password are accurate
* ✓ User has permissions for the specified database
***
## Start Analyzing Your Data
Once connected, simply ask Julius about your data in plain English:
"Show me all customers from the users table"
"What's the average order value this month?"
"Create a chart of sales by region"
"How has revenue changed over the past 6 months?"
**No SQL required!** Julius automatically writes and executes queries based on your natural language requests.
***
## Security & Compliance
Certified to meet strict security standards
All credentials and data encrypted in transit and at rest
Julius only queries what you request—never stores your data
Learn more about how Julius protects your data and maintains compliance
***
## Best Practices
Create a dedicated MySQL user with SELECT-only permissions to prevent accidental data modification.
```sql theme={null}
CREATE USER 'julius_readonly'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT ON your_database.* TO 'julius_readonly'@'%';
```
Verify your connection works correctly using a development or staging database before connecting to production.
Work with your database administrator to ensure proper security policies and performance guidelines are followed.
Keep an eye on database load when running complex queries through Julius, especially on production systems.
***
## Troubleshooting
If you see an error like `Read timed out` or `Connection timed out while trying to reach the service`, check the following:
**Possible causes:**
* Incorrect host or port
* Database doesn't allow external connections
* Database is offline or unreachable
**Possible causes:**
* Wrong username or password
* User lacks database permissions
* Database name misspelled
**Solution:** Double-check credentials and verify user permissions
**Possible causes:**
* User lacks read permissions on tables
* Connected to wrong database
* Tables don't exist in specified schema
**Solution:** Verify user has SELECT permissions and correct database is specified
***
## Need Help?
Questions? Reach out to **[team@julius.ai](mailto:team@julius.ai)** for assistance