MySQL / MariaDB

Connect to MySQL and MariaDB databases, including managed services like Amazon RDS, Google Cloud SQL, and PlanetScale.

Prerequisites

Before creating a connection, you need:

1. A MySQL or MariaDB database that is publicly accessible from the internet
2. A database user with read permissions on the tables you want to query

Network access

Your database must be publicly accessible from the internet for Reeflow to connect. If your database is behind a firewall or VPC, you will need to allow Reeflow’s egress IPs.

Creating a read-only database user

For security, create a dedicated read-only user for Reeflow rather than using an admin account. This limits the potential impact if credentials are compromised.

UsernamePasswordDatabase

-- Create the user
CREATE USER 'reeflow_reader'@'%' IDENTIFIED BY 'your-secure-password';

-- Grant read access to the target database
GRANT SELECT ON your_database.* TO 'reeflow_reader'@'%';

-- Apply the new privileges
FLUSH PRIVILEGES;

Restricting access to specific tables

To restrict the user to a subset of tables, grant SELECT per table instead of on the whole database:

GRANT SELECT ON your_database.orders TO 'reeflow_reader'@'%';
GRANT SELECT ON your_database.customers TO 'reeflow_reader'@'%';

Configuration

When creating a MySQL / MariaDB connection in Reeflow, provide the following:

Field	Description
Host	Hostname or IP address of your MySQL / MariaDB server
Port	Database server port (default: 3306)
Username	The read-only user you created (e.g., reeflow_reader)
Password	Password for the database user
SSL	Enable SSL/TLS encryption for the connection
Database	Default database queries are issued against

Tip

Always enable SSL for production databases to encrypt data in transit.

Creating a connection

Create a MySQL / MariaDB connection

Add a MySQL or MariaDB database as a data source in Reeflow.

Navigate to Connections in the main navigation, then click New Connection.

Enter a Name for the connection and an optional Description.

Select MySQL / MariaDB as the connection type.

Enter your database Host, Port, Username, and Password. Enable SSL for production databases.

Pick the database queries should run against from the Database dropdown. The list is populated automatically from the credentials you entered above.

Click Create Connection to save. The connection appears in your connections list.

1

2

3

4

5

6

Navigate to Connections in the main navigation, then click New Connection.

Enter a Name for the connection and an optional Description.

Select MySQL / MariaDB as the connection type.

Enter your database Host, Port, Username, and Password. Enable SSL for production databases.

Pick the database queries should run against from the Database dropdown. The list is populated automatically from the credentials you entered above.

Click Create Connection to save. The connection appears in your connections list.

PreviousNext

Related

• Connections overview
• Connection and table security