Connect to MySQL
Connect your MySQL database to VexiData for natural language querying and dashboard creation.
Connect your MySQL database to VexiData for natural language querying and dashboard creation. Connection takes about 2 minutes.
Prerequisites
- A VexiData account (free tier available)Create account
- MySQL database (version 5.7 or higher) or MariaDB 10.2+
- Database credentials: hostname, port, database name, username, and password
- Network access from VexiData to your database (port 3306 open)
Connection Steps#
1
Navigate to Data Sources
From your VexiData dashboard, click on Data Sources in the menu.
2
Select MySQL
Under the Add New Data Source section, click on MySQL to open the connection dialog.
3
Enter Connection Details
Fill in your MySQL connection information:
text
Display Name: My MySQL Database
Host: your-database-host.com or IP address
Port: 3306 (default MySQL port)
Database: your_database_name
Username: vexidata_readonly
Password: your_secure_password4
Configure SSL (Optional)
For production databases, enable SSL for encrypted connections. Most cloud MySQL providers support SSL connections.
5
Test and Save
Click Test Connection to verify connectivity. Once successful, click Save Connection to start using your database.
Connection String Format#
If you prefer using a connection string, here's the format VexiData accepts:
text
mysql://username:password@hostname:3306/databasename
Example:
mysql://vexidata_readonly:mypassword@db.example.com:3306/sales_db