Spanrr
Search…
Connect MySQL DB
You can connect your MySQL databse by following these steps:
    1.
    Go to your homepage (https://app.spanrr.com/)
    2.
    Click on the Add Data button
    3.
    On the dialog box click choose the MySQL option

Connect MySQL

You need to provide the following details for the connection:
    Name: The name by which you would like to refer to this data source
    Host: The address of the machine where mysql server is running (ex: 65.123.123.123)
    Database Name: The schema of the DB to connect to
    Username: The username which will access the DB
    Password: The password corresponding to the user
    Port: The port number 3306 is used by default

IP Whitelisting

To ensure security of your production MySQL DB you can consider whitelisting our IP to access your DB. Spanrr IP address is 65.2.95.121
IP whitelisting is generally done by enforcing inbound IP rule on your server/infrastructure provider.

AWS RDS

AWS RDS runs in a virtual private cloud so there are a couple of extra steps needed to allow Spanrr to connect to AWS RDS:
    1.
    Make it publicly accessible
    2.
    Ensure you update inbound rule to include Spanrr's IP.

Public Access on RDS

    1.
    Select your DB instance in the RDS Databases page and click on Modify
    2.
    Go to Connectivity section and expand "Additional Configuration"
    3.
    Select "Publicly accessible" as shown below
    4.
    Click on continue to apply the changes
Switch the access to Public

Allow Spanrr IP to access the RDS instance

    1.
    Select your DB instance and click on its name to go to details page.
    2.
    Under "Connectivity and Security" tab click on your security group
    3.
    Under the "Inbound Rules" tab select "Edit Inbound rule"
    4.
    Click "Add rule". Select "MySQL/Aurora" under the type. Set the source value as "65.2.95.121/32" as shown below.
    5.
    Click "Save rules
Add an Inbound rule for Spanrr's IP address
Last modified 1mo ago