Configuring MySQL

Read the article and follow the step-by-step instructions for configuring MySQL with Intentwise analytics Cloud

Richa Gupta avatar
Written by Richa Gupta
Updated over a week ago

Steps for configuring MySQL

To configure MySQL with Intentwise analytics Cloud, please follow the below instructions:

1. Create a new database ‘intentwise' in the MySQL cluster

2. If your database is behind the firewall, whitelist the following IP addresses. This is required for the Intentwise data pipeline to access your database

  • 52.25.90.16

  • 52.68.49.96/32

  • 52.26.72.39/32

  • 52.48.81.207/32

  • 54.86.110.101/32

  • 52.64.101.124/32

  • 52.74.180.132/32

  • 18.196.243.206/32

3. Create a new user <intentwise_user> with the <password> in your MySQL database

4. Create the following two new schemas within the database:

  • amazon_source_data

  • intentwise_ecommerce_graph

5. Grant read/write permissions for the user created in step #3 by using these queries:

  • GRANT ALL PRIVILEGES ON amazon_source_data TO <intentwise_user>;

  • GRANT ALL PRIVILEGES ON intentwise_ecommerce_graph TO <intentwise_user>;

6. Now, go to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on "+ Add Destination", choose MySQL as the destination and click Next


7. And enter the Host, Port, Database, User, and Password details and Save

8. On successful completion, you will see the below message:

9. For any further question on the pipeline setup, please email us at [email protected] .

Did this answer your question?