How to Get Started with MySQL on Zapier

Connect to MySQL on Zapier

MySQL uses custom authentication to authenticate your account on Zapier. To connect to MySQL, you’ll need to provide a static IP address listed below.  
 

Required authentication fields

  • Host: This is your database instance's IP address or hostname (db.example.com). It must be accessible from outside your network. Note: localhost and 127.0.0.1 are not valid. Make sure it is accessible from these IPs: 54.86.9.50
  • Port: 3306 is the default. Change it if you're using a non-standard port.
  • Database: This is the name of the database to read data from.
  • Username: This is the username that will access the database. You should create a new Zapier-specific user with a limited permission scope.

Optional authentication fields

  • Password: This is the password of the database to read data from.
  • Enforce encryption: Select from the dropdown menu to enforce SSL/TTL for encrypting communication between Zapier and your database. 
  • SSL client certificate: Use if your server requires client validation for SSL.
  • SSL private key: Use if your server requires client validation for SSL.
  • SSL CA bundle: Use to provide a PEM-formatted certificate chain file. This is also known as a Certificate Authority (CA) file or CA Bundle.

Learn more about authenticating your MySQL account in Zapier.

About MySQL's app

Are self-hosted or cloud-hosted accounts supported? Self-hosted and cloud-hosted accounts If you're using MySQL version 8, you must use the mysql_native_password for authentication plugin. SHA2 authentication isn't supported at this time.
Is a paid MySQL plan required? No  
Are any special account permissions required? Yes

You must allow Zapier to connect in:

  • Network
  • Server
  • SQL server

Are there usage limits? N/A  
Are there pagination limits? N/A  
Do trigger samples use real data from your account or generic data? Real sample data  
Are custom fields supported? Yes  
Do update actions overwrite or append to existing data? Overwrite existing data  
Is there any additional info? Yes
Was this article helpful?
2 out of 6 found this helpful