Skip to main content

Required settings

  • Host name
  • Port (default is 3306)
  • Service account

Creating a service account

-- Create the service account
CREATE USER 'artie' IDENTIFIED BY 'password';

-- Grant the necessary permissions to the service account for us to merge data and manage schema evolution.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO 'artie';