Connect your dataSupported integrations
MySQL
Connect MySQL to Querio.
1. Create a dedicated user
What: Create a non-human MySQL user for Querio.
CREATE USER 'querio_user'@'%' IDENTIFIED BY 'STRONG_PASSWORD';You can replace % with Querio's IP address for tighter network access.
2. Grant read-only access
What: Give Querio access to the database it should query.
GRANT SELECT ON my_database.* TO 'querio_user'@'%';
FLUSH PRIVILEGES;For tighter access, grant permissions on specific tables instead of the whole database.
3. Share connection details
Provide:
- Username
- Password
- Host
- Port, usually
3306 - Database
Connection string format:
mysql://<username>:<password>@<host>:<port>/<database>