MySQL is currently the most popular database management system software used for managing the relational database.
Looking for the MySQL Alternatives? Here is the list of top MySQL Alternatives
Triggered when you add a new row.
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
Triggered when you add a new table.
Adds a new row.
Delete a row.
Updates an existing row.
Finds a row in a table via a lookup column.
Integrate MySQL with Appy Pie Connect and automatically capture information from other apps you use and store them directly to MySQL. Automatically update a row in MySQL from a trigger you set up for other apps you use. On the other hand, whenever something changes in your database, you can save it all in a spreadsheet, CMS, or other data organizational apps for your record. With Appy Pie Connect MySQL easily integrates with Gmail, Slack, MailChimp, Google Sheets, Typeform, Google Calendar, Trello, Slack, Salesforce, and more without any coding. Use MySQL with Appy Pie Connect and keep your data organize and safe.
MySQL is one of the best data management systems that allow you to manage all your relational databases. It gives you the flexibility and ability to customize storage as per your needs. Connecting MySQL with other apps you use in your business can make your data storage more efficient. With Appy Pie Connect, you can integrate MySQL into more than 150 apps without any coding. Appy Pie Connect offers some of the most effective MySQL integrations that are designed around your needs.
Appy Pie Connect brings together Triggers (like "New Rows") and Actions (like "Send Email") to complete an action in one app whenever a trigger occurs in another. This phenomenon is called “Connect” and these Connects help you automate repetitive tasks saving you the trouble of doing them manually.
To connect My SQL to Appy Pie, you must click Connect My SQL to your favorite apps button. To do so, sign up/log into your Appy Pie and visit your access dashboard.
Now, select your required service and click Continue. Here, you’ll be asked to select your account and press Connect an Account button.
A pop window will appear to enter the Host, Port, Database Name, Username, Password, SSL Client Certificate and SSL Private Key for the account you want to integrate at Appy Pie Connect.
Once the details are filled you will be asked to give permission for the integration, Click Yes, Continue complete this step. Now, fill the required fields and you’re done!
Note: Our database is completely encrypted and we store the encryption keys with us in a separate secured storage. We still recommend you to create a separate intermediate database to link with Appy Pie Connect. This will keep your main product information safe and secured. To link both of the databases you can use an out-of-band process so that the data could be dumped from the intermediate database to the main product database.
Database connection can be tricky sometimes, check a few things here:
Which version of MySQL are you using?
Appy Pie Connect is supporting MySQL versions below 8.0 and thus you can integrate your database below this version only.
Check IP restriction over database
It is majorly for non-AWS hosts like HostGator, DigitalOcean etc. Appy Pie Connect is currently using a static IP to connect your database, the IP address is: 184.108.40.206
Note: Keep your firewall open and add IPs to GRANT All permits to the user
You can grant all privileges to Appy Pie Connect to check the functionality and then clip the permissions unnecessary.
For PostgreSQL, configure the server to accept logins from external IPs (in pg_hba.conf), and then make Appy Pie Conect a user to use.
Check if the database is listening on public interface?
Check if the database is bound to only listening to 127.0.0.1, try removing restrictions or binding it to 0.0.0.0. Check my.conf, postgresql.conf or similar configuration.
Are you using Amazon RDS/EC2 or Heroku?
Make sure that database is accessible on : 220.127.116.11/32
Check if you are using VPC or Classic Platform.
Check if you are on the classic platform, go to the left hand navigation bar and click “Security Groups” available under RDS.
Add the above given IP as CIDR/IP authorization in your database instance under the security group you are using.
Check and test the IP set and you shall be ready to work.
For VPC users, kindly make it publicly accessible and whitelist the above given IP. Check further details for accessing DB instances in VPC and Classic DB.
How to Authorise Appy Pie Connect IP on Google Cloud Platform & CloudSQL?
To add and authorise 18.104.22.168 IP follow the instructions given below:
Reconfirm Username, Password, SSL Certificates
It is important to check username, passwords and SSL certificates for any typos, spaces or any other mistakes.
Check the Database speed!
Appy Pie Connect queries run within 30 second, keep checking whether everything is working fine. If you have WHERE clauses added to indexes make sure that your id has index as well.
New Rows Aren’t Triggering!
Your Appy Pie Connect setup might have stopped working, here is what might have had happened:
Check for Connect filters, Order By field must be selected under “edit option” for MySQL trigger.
You must select the field to pull the particular records from the database (we only take a certain number of entries at a time). We shall get the default order if the order by field is not selected properly.
Check the primary key, it should be on auto increment mode, date creation is also good for Connect. Remember, leaving these fields can be one of the reasons that you connect has stopped triggering new rows.
Kindly contact our support team online to get more information.