MySQL Integrations
Use Appy Pie Connect and Integrate MySQL with 150+ Apps to automate your business process in minutes.
About MySQL
MySQL is an open source relational database management system that powers your web-based, custom and embedded database applications securely, reliably, and cost-effectively. With its proven performance, and ease-of-use, it has become the leading choice in database for web-based applications, used widely by high profile web properties.
Read MoreMySQL Alternatives
Looking for the MySQL Alternatives? Here is the list of top MySQL Alternatives
-
Firebase
-
MongoDB
-
PostgreSQL
Choose the app you want to connect with MySQL
Oops!
Don't see a web app you need?
We're constantly adding new ones to Connect based on customer requests.
Email Us the Apps you'd like to add
-
Airtable
-
Premium
Vend
-
Zoom
-
Premium
MINDBODY
-
SugarCRM
-
Amazon SQS
-
Expensify
-
Premium
Microsoft Dynamics 365 Business Central
-
Microsoft Exchange
-
Premium
Google Groups
-
Shippo
-
Shipwire
-
Premium
MailChimp Ecommerce
-
Tableau
-
BambooHR
-
ClickUp
-
Premium
RingCentral
-
Premium
SMS By Connect
Popular MySQL Integrations
-
MySQL + Google Sheets
Create rows on a Google Sheets spreadsheet for new MySQL rows Read More...When this happens...
New Row
Then do this...
Create Spreadsheet Row
This integration from Appy Pie Connect eases your data transfer process between Google Sheets and MySQL. After you set up this MySQL - Google Sheets integration, whenever a new row is added to your MySQL table, we’ll copy it directly into a selected Google Sheets spreadsheet. Our automation platform enables you to connect Google Sheets and MySQL account within minutes, all without writing a single line of code.
Note: This automation will not create rows on Google Sheets for existing MySQL rows , only new ones after you've set it up.
How It Works- A new row is created on MySQL
- Appy Pie Connect automatically copies it to a selected Google Sheets
What You Need- A MySQL account
- A Google account
-
Trello + MySQL
Create new rows in a MySQL table for new Trello card activity Read More...When this happens...
New Activity
Then do this...
Create Row
You can automatically archive all of your Trello card activities in a MySQL table using this MySQL - Trello integration. Once set up, whenever an activity happens on a Trello card, a new row will be created in a MySQL table. This integration will help you manage your Trello database without any manual effort at your end.
Note: This integration only creates MySQL rows for Trello card activities that happen after you've set it up.
How It Works- A new activity happens on a Trello card
- Appy Pie Connect automatically adds a new row to a MySQL table
What You Need- A Trello account
- A MySQL account
-
Gmail + MySQL
Add rows in MySQL for New Emails in Gmail [REQUIRED : Business Gmail Account] Read More...When this happens...
New Email
Then do this...
Create Row
Gmail is one of the most used email services across the world and it efficiently uses a variety of signals to predict which messages are important, including the people you email the most and which messages you open and reply to the most. Use our Gmail-MySQL integration and add all Gmail emails (or those with a certain label) to your database. Once this integration is active, it will trigger for every new message received on Gmail, automatically adding a new row to your MySQL database.
Note: To use this integration you must have a Business Gmail account.
How it works- A new email is received on Gmail
- Appy Pie Connect automatically creates a new row on a MySQL database.
What You Need- A Gmail account
- A MySQL account
-
When this happens...
{{item.triggerTitle}}
Then do this...
{{item.actionTitle}}
MySQL Integration Details
Use Appy Pie Connect with MySQL to automatically capture information from other apps you use and store them directly to MySQL. You can 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. Our automation platform allows users to connect MySQL with more than 100 other apps without any coding. Put the process on autopilot and rest assured that your data in MySQL is up-to-date with MySQL-Appy Pie Connect integration.
We have listed some of the most creative ways in which you can use MySQL to its maximum potential with Appy Pie Connect:
- Keep a track of all your Typeform. Appy Pie Connect automatically captures your Typeform form entries and copy them into your MySQL database.
- Save MySQL data changes in data organizational tools. Use Appy Pie Connect to create a new row on a Google Sheets spreadsheet whenever changes are done in MySQL database.
- Monitor your database without logging. Appy Pie Connect will send a new message via Gmail whenever a new row is added to a MySQL table.
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.
Step By Step MySQL Integration Guide
To integrate MySQL app at Appy Pie Connect, search and select the app from the app directory of Appy Pie Connect. Choose the service required and press Continue to move further ahead with the integration.
Click Connect an Account and fill the details such as Host, Port, Database Name, Username, Password, SSL Client Certificate and SSL Private Key in the pop-up form to connect MySQL with Appy Pie Connect. Press Yes, Continue button after filling all the details correctly.
(SSL Client Certificate and SSL Private Key are optional you can use MySQL certification)
Appy Pie Connect will ask you to verify the account once more and press Continue.
Enter the details from the drop-down and press Continue to complete the integration at Appy Pie Connect.
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.
Common Issues in Connecting Database At Appy Pie Connect
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:
- 52.6.4.95
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 : 52.6.4.95/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 52.6.4.95 IP follow the instructions given below:
https://cloud.google.com/sql/docs/mysql/configure-ip
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 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.
