MySQL

How to connect Datalogz to MySQL

In Short

You can set up a MySQL integration with Datalogz in four easy steps:

1. Create Datalogz User in MySQL

2. Select Add Data Source, click MySQL

3. Provide your credentials

4. Schedule automatic updates

Step 1: Create Datalogz User in MySQL

Make sure you run these commands as "ACCOUNTADMIN".

-- Create a user named "Datalogz_User" that Datalogz will use when connecting to your MySQL database. CREATE USER 'Datalogz' IDENTIFIED BY PASSWORD '<enter password here>' '';

-- Complete this query for any schemas you would like Datalogz to read GRANT SELECT ON DATABASE <yourdbname> TO Datalogz;

Step 2: In Datalogz navigate to adding a MySQL Database

1. Login as an admin

2. Click 'Add New Data Source' in the left navigation bar

3. Select MySQL

Step 3: Provide your MySQL Credentials

You will need to fill in your MySQL credentials. Below is an example of the credentials required:

1. Username: Datalogz

2. Password: xxxxxxx

3. Hostname: myhostname.ap-us-east-2.rds.amazonaws.com

4. Port: 5432

5. DB Name: database-1

6. Data Access Location: direct link to your MySQL endpoint (Optional)

Once you have filled in the details, click on "Add MySQL Data Source ".

Step 4: Schedule Automatic Updates

1. Click 'Manage Schedules' in the left navigation bar

2. Click 'Configurations'

3. Select your desired update time

4. Select your MySQL Data Source

5. Click 'Create Job'

Remember to whitelist the IP address shared with you from Datalogz. IP Address: 20.72.176.193