MySQL

MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. 

AppiWorks is an application integration and automation platform. It can create a connection to MySQL in the AppiWorks platform and use it in any sub-products such as Blooms, Forms, Flows, and client platforms such as AppiWorks for Zoho CRM, AppiWorks for Google Forms, AppiWorks Looker Studio Connector, etc.

Before setting up the MySQL connection in the AppiWorks platform, one must configure the MySQL in any of the cloud providers such as GCP, AWS, etc. (can be any other providers), you can visit the following links for your reference

GCP - https://cloud.google.com/sql/docs/mysql/create-manage-databases

AWS - https://aws.amazon.com/getting-started/hands-on/create-mysql-db/

***IMPORTANT NOTE***

The following IP range should be whitelisted in your cloud/ on-premise MySQL database so that AppiWorks Infrastructure can connect with it.

35.238.134.134

How to do a whitelist?

Method 1: Using MySQL Users and Hosts

1. Access MySQL Console:

   • Open a terminal and log in to the MySQL console using:

mysql -u username -p

1. • Enter your MySQL password when prompted.

2. Create or Modify User:

   • Create a new user:

CREATE USER 'new_username'@'whitelisted_IP' IDENTIFIED BY 'password';

2. • Modify an existing user:

GRANT ALL PRIVILEGES ON database_name.* TO 'existing_username'@'whitelisted_IP';

3. Apply Permissions:

FLUSH PRIVILEGES;

Method 2: Using Firewall Rules (if available)

1. Access Control Panel:

   • Login to your hosting provider's control panel (e.g., cPanel, Plesk, SiteWorx).

2. Find Firewall Settings:

   • Locate the section for firewall or security settings.

   • Look for options to whitelist IP addresses for MySQL.

3. Add Whitelist Entries:

   • Enter the specific IP addresses you want to allow access to MySQL.

   • Save the changes.