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
Go to Wobby → Data Sources.
Click New MySQL Connection.
Fill in the following details:
Host: your MySQL server hostname or IP address
Port: default is
3306
unless changedDatabase: the default database Wobby should use
Username:
wobby_user
Password: the secure password you set
SSL: enable if your MySQL instance requires encrypted connections
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.
Last updated
Was this helpful?