Comment on page
This page describes how to sync data to your MySQL database.
This guide will walk you through connecting to MySQL as a destination.
To use MySQL as a destination, Census requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.
-- Note that creating a user may be redundant if you're already configured
-- MySQL as a source.
-- Create census user the ability to sign in with a password
CREATE USER CENSUS IDENTIFIED BY '<strong, unique password>';
-- GRANT access to which ever schemas you'd like to give access to
-- Note: this can also be granted to specific tables as well
GRANT INSERT, UPDATE, SELECT ON <your schema>.* TO CENSUS;
Census can successfully connect to MySQL instances that are using advanced networking controls including region constraints, IP address allow lists, or SSH Tunneling. For more information, see our Network Access Controls documentation.