A guide to whitelist Superjoin’s IP address in your MySQL server to connect MySQL to Google Sheets using Superjoin.
#1 Speak to your IT Admin
Provide the IP
Request Whitelisting
Test the Connection
Reach Out for Support
#2 Whitelist it yourself
Log Into Your Server
Edit Config (1/3)
/etc/mysql/my.cnf
or similar) using a text editor.Edit Config (2/3)
bind-address
directive and change its value to 0.0.0.0
to allow connections from any IP (be cautious with this setting).Edit Config (3/3)
skip-networking=0
is set under [mysqld]
. Save and exit.Restart MySQL
sudo service mysql restart
to apply changesGrant Access to Superjoin
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;
Reach Out for Support
#3 Whitelist in Google Cloud (Cloud SQL)
Navigate to Google Cloud Console
Authorize Networks
Reach Out for Support