How to whitelist IP addresses for Database access

When working with Two Minute Reports, you might be required to whitelist IP addresses so that your database can accept connections from us. Without connecting to your database we can’t pull the data required for creating your reports.

We have created easy to use scripts and commands for your to quickly do the whitelisting. These scripts are dependant on the database types that you want to add to your Two Minute Reports account.

Please note we don’t allow or execute any other query apart from “SELECT” queries from Two Minute Reports. These scripts below enable only “SELECT” access to your database and are therefore safe. Queries that modify your database’s data cannot be executed from Two Minute reports.

Whitelist IP address in MySQL

To whitelist IP addresses and enable access to Two Minute Reports you can use these readymade scripts and commands that we have created for you. Choose one of the two method based on your choice of request origin, Google or Amazon that you selected while adding a MySQL data source in Two Minute Reports.

Amazon IP

If you chose Amazon as your request origin, you need to whitelist just one IP address. Two Minute Reports’ servers are hosted by Amazon Web Services. Our IP addresses are 54.242.82.213, you can easily whitelist it using the following commands.

Step 1

Login to mysql console using the following command in your terminal

mysql -u userwithgrantacccess -p 

Step 2

Run these following commands from inside the mysql console, after modifying them as per your needs.

CREATE USER 'newDbUsername'@'54.242.82.213' identified by 'newDbPassword';"
GRANT SELECT ON yourDatabaseName.* TO 'newDbUsername'@'54.242.82.213';"

Hope these instructions helped you. Please don’t hesitate to contact us incase you are facing any difficulties.

Was this helpful?