Common Issues and Troubleshooting

Below is a checklist of common problems that can prevent a successful database connection. We recommend reviewing these points first. If you're still having trouble, don’t hesitate to contact us—we’re happy to help resolve any connection issues.

Ensuring Your Database is Accessible from the Internet

  • Whitelisting Our IP Address

    One frequent issue is that the server hosting your database may not be configured to accept traffic from external sources. Check with your cloud provider on how to allow inbound connections. In most cases, you’ll want to restrict access rather than allow open traffic—so the recommended approach is to whitelist the DataReportive IP address. You can find this IP on the page where you add a new Data Source.

  • Reviewing Firewall Permissions

    If your server is behind a firewall, it may be blocking incoming requests. Verify your firewall settings and ensure they allow traffic from the DataReportive IP.

  • Checking Cloud Provider Access Settings

    Most cloud providers default to restricted access. Review your provider’s documentation or contact their support team to understand how to allow external connections to your database.

Configuring a User with the Right Permissions

Ensure the database user you're connecting with has the proper permissions for remote access. For MySQL, you can refer to this helpful example on how to grant remote access.

Verifying Your Setup

To confirm everything is correctly configured, try connecting to your database from a third-party application outside your local network. Tools like Sequel Pro, MySQL Workbench, or pgAdmin can be used to test remote access.