Initial MySQL Database Connection Setup

• First, you must have a MySQL database set up and running.
• Ensure that you have the necessary credentials to access the database.
  User must have permissions to ALTER, CREATE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, DELETE
• Enter the necessary details such as database host, port, username, password, and database name. Ensure that the details are accurate and match the credentials you have for your MySQL
• Test the connection to ensure our app can successfully connect to your MySQL database. If the connection is successful, you will receive a confirmation message.
• Ensure you fill in your contact information once the connection is established. This will allow you to receive alerts in case of connection failures or any other issues that may arise.
• Monitor your database to ensure tables are being created prefixed with “dbsync_”.
• Congratulations! You have successfully connected your MySQL on DBSYNC app and can now combine Shopify data with your organization’s on-premise data and run analysis tasks.

Our app will begin syncing your store's orders as soon as the MySQL database connection is established. However, to sync all of your historical orders or resync missing orders due to connection failure, database downtime or any other issues, you can use our Get Historical Orders feature