Set up a MySQL data destination to export data from Singular automatically to a MySQL server. Note: data destinations are a premium feature (learn more).
1. Create a Database and User in MySQL
Create a new database with the following command:
CREATE DATABASE singular;
Create a new user with the following command:
CREATE USER 'singular'@'%' IDENTIFIED BY '<password>';
Grant the user the following permissions:
GRANT ALL PRIVILEGES ON singular.* TO 'singular'@'%';
Note: This allows Singular to create new tables in the provided database and schema. It does not allow Singular to read or change other schemas or tables in the database.
2. Whitelist Singular Server IPs
If you are using a firewall and only allow certain IPs to connect to your MySQL instance, you need to add Singular’s servers to the whitelisted IPs in your policy These are the IPs:
3. Add a MySQL Data Destination
To add a MySQL data destination in Singular:
- In your Singular account, go to Settings > Data Destinations and click Add a new destination.
Type in "MySQL".
In the window that opens, fill in the relevant details:
Field Description Username The username and password you created in Step 1. Password Hostname The hostname of your MySQL instance. Database Name The database that you granted Singular permissions to. Table Name Enter a name for the table that Singular will create and write to. Default: "marketing_data".