What is 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. 

What is AppiWorks integration with MySQL?

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.

Setup and Configuration

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




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

How to do a whitelist?

Method 1: Using MySQL Users and Hosts

mysql -u username -p

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

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


Method 2: Using Firewall Rules (if available)

How to establish a connection?

Note: You can find the credentials while setting up the configuration in cloud providers (check the Setup & Configurations section above)

Troubleshooting and Support