Superjoin’s IP Address is 34.100.193.122. Whitelist this IP Address in your database and allow TCP/IP connection from this IP in your firewall.

​
What is “Whitelisting”?

Think of your database like a private party. The “whitelist” is your guest list. Only the IP addresses (unique identifiers for computers on the internet) on this list can “enter the party,” i.e., connect to your database. IPs not on the list will receive the metaphorical “you’re not on the list” and cannot connect.

​
Step by Step Guide to IP Whitelisting in your MySQL DB

If you’re ready to handle this yourself, here’s how you can whitelist IP addresses for MySQL.

Solution

1

Log Into Your Server

Use SSH to access your server where MySQL is hosted.
2

Edit Config (1/3)

Open the configuration file (/etc/mysql/my.cnf or similar) using a text editor.
3

Edit Config (2/3)

Locate the bind-address directive and change its value to 0.0.0.0 to allow connections from any IP (be cautious with this setting).
4

Edit Config (3/3)

Ensure skip-networking=0 is set under [mysqld]. Save and exit.
5

Restart MySQL

Use sudo service mysql restart to apply changes
6

Grant Access to Superjoin

Log into MySQL with mysql -u root -p. & Run the Command GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'34.100.193.122' IDENTIFIED BY 'your_password'; FLUSH PRIVILEGES;

Replace placeholders with your actual database name, username, and password.

7

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
1

Navigate to Google Cloud Console

Go to the SQL section and select your instance.
2

Authorize Networks

Edit settings and under Authorized Networks, add Superjoin’s IP 34.100.193.122. Save your changes.
3

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.

​
AWS Whitelisting

Looking to whitelist in AWS?

Head over to the IP Whitelisting in AWS page to get a step by step troubleshooting guide.

Whitelisting an IP for your MySQL, Amazon Redshift, or PostgreSQL database doesn’t just bolster security—it ensures that only authorized locations can access your data. Whether you choose to manage this process yourself or coordinate with IT professionals, ensuring your database’s security is crucial. Remember, if you’re ever unsure, consulting with an expert is always a wise decision. Happy data managing!

Was this page helpful?

OverviewTroubleshooting