How to Get Started with MySQL on Zapier

Written by Owner

Updated at August 20th, 2025

+ More

Table of Contents

Connect to MySQL on Zapier Required authentication fields Optional authentication fields About MySQL's app

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	Can't access or use Zapier with other apps Can't connect to my database Database service deduplication

How to Get Started with MySQL on Zapier

Contact Us

Connect to MySQL on Zapier

Required authentication fields

Optional authentication fields

About MySQL's app

Related Articles