Connecting MySQL to Workflows requires you to have: 1. A MySQL user with read/write access to the database and all associated tables/views you wish to access. We recommend setting up an account specifically for Workflows access, although you can use an existing user. 2. Workflows IP Addresses whitelisted
Creating a New User
-
Login to your MySQL server
-
In the command line, connect to a database by running
USE <database name> -
In the command line, create a user by running
CREATE USER <user name> WITH PASSWORD '<new password>'; -
The MySQL server URL, the username, and password are all used in the Blueprints below