MySQL

MySQL is an open-source relational database management system (RDBMS).

Provisioning Access with Roles (v8.0+)

Create user

As a super user, execute the following SQL commands to create a group, a user assigned to that group, and permissions to access and monitor system tables.

Make sure to generate a secure password and store it securely — you'll save it into Metaplane later.

CREATE ROLE metaplane_role;
GRANT REFERENCES ON *.* TO metaplane_role;
GRANT USAGE ON *.* TO metaplane_role;
GRANT SELECT ON *.* TO metaplane_role;

CREATE USER metaplane_user IDENTIFIED BY 'password123';

GRANT metaplane_role to metaplane_user WITH ADMIN OPTION;
SET DEFAULT ROLE metaplane_role TO metaplane_user;

Granting permissions to tables in a schema

Then for each schema schema_name, execute the following three commands to grant read-only access:

-- Grant usage on schema and select on current and future child tables
GRANT USAGE ON schema_name.* TO metaplane_role;
GRANT SELECT ON schema_name.* TO metaplane_role;
GRANT ALL PRIVILEGES ON schema_name.* TO metaplane_role;

Provisioning Access without Roles (< v8.0)

CREATE USER metaplane_user IDENTIFIED BY 'password123';

GRANT REFERENCES ON *.* TO metaplane_user;
GRANT USAGE ON *.* TO metaplane_user;
GRANT SELECT ON *.* TO metaplane_user;

Adding MySQL source

To add a source, navigate to the Connections page and click the MySQL button. A modal will prompt you for the credentials you just created, then allow you to save the connection for testing:


Whitelisted IPs

Metaplane will always connect to your data warehouse from these static IP addresses:

  • 52.22.202.169/32
  • 34.199.237.80/32
  • 54.227.153.130/32
  • 34.230.219.122/32
  • 44.197.96.121/32
  • 34.206.79.174/32
  • 107.22.42.246/32

What’s Next
Did this page help you?