MySQL

Connect a MySQL Database to Wobby

Connect MySQL to Wobby

To connect your MySQL database to Wobby, follow these steps:

• Create a read-only user account.

• Grant access to the necessary databases and tables.

• Set up the connection in the Wobby interface.

⚠️ Wobby’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 Wobby will use to query your data. This user should be restricted to only what’s necessary for analysis.

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

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

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

---

2. Grant Read-Only Access to Data

Decide which databases and tables Wobby should access, typically your reporting or analytics schemas.

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

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

 SELECT ON your_database.sales_data TO 'wobby_user'@'%';
GRANT SELECT ON your_database.customer_summary TO 'wobby_user'@'%';

✅ For multi-schema environments, repeat the grant process for each schema or table Wobby 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 Wobby

1. Go to Wobby → Data Sources.

2. Click New MySQL Connection.

3. Fill in the following details:

   • Host: your MySQL server hostname or IP address

   • Port: default is 3306 unless changed

   • Database: the default database Wobby should use

   • Username: wobby_user

   • Password: the secure password you set

   • SSL: enable if your MySQL instance requires encrypted connections

4. Test the connection and click Save.

📂 Wobby only queries the data the user can see—if the user doesn’t have access, Wobby won’t either.

---

That’s It!

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