How to get started with MySQL on Zapier

MySQL and Zapier connect to automate database tasks. You can trigger actions when new rows are added and create or update rows in tables.

Available on plans:

Free

Pro

Team

Enterprise

Prerequisites

To use the MySQL app on Zapier, you must have:

• Database access and configuration:
  • A MySQL database that is accessible from outside your network (not localhost or 127.0.0.1) and configured to listen on a public interface.
  • For MySQL version 8, you must use the the mysql_native_password authentication plugin as SHA2 is not supported.
  • If hosted on AWS RDS/EC2 or Google Cloud Platform, add Zapier's IP address (54.86.9.50) to your security group or authorized networks.
• User and permissions:
  • Create a dedicated MySQL user account with appropriate permissions.
  • Include IP-specific GRANT statements for Zapier's IP address (54.86.9.50).
• A paid Zapier plan. MySQL is a premium app on Zapier.

Connect MySQL to Zapier

To create an app connection to MySQL on Zapier:

• Go to the Apps page.
• Click + Add connection.
• A new dialog box will appear. Search for and select MySQL.
• Click Add connection.
• A Connect an Account page will open in a browser tab or window.
• Complete the following fields:
  • Required fields:
    • Host: Enter your database instance's IP address or hostname (e.g., db.example.com). It must be accessible from outside your network. localhost and 127.0.0.1 are not valid.
    • Port: Enter your database port number (3306 is the default).
    • Database: Enter your database name to read data from.
    • Username: Enter your database username (create a new Zapier-specific user with limited permission scope).
  • Optional fields:
    • Password: Enter your database password.
    • Enforce encryption: Select from the dropdown menu to enforce SSL/TTL for encrypting communication between Zapier and your database (optional).
    • SSL client certificate: Enter your SSL client certificate if your server requires client validation for SSL (optional).
    • SSL private key: Enter your SSL private key if your server requires client validation for SSL (optional).
    • SSL CA bundle: Enter your PEM-formatted certificate chain file, also known as a Certificate Authority (CA) file or CA Bundle (optional).
• Click Yes, Continue to MySQL.

Your MySQL account is now successfully connected to Zapier.

About MySQL's app

Triggers, searches, and actions

Triggers

• New Column (Polling) - Triggers when you add a new column.
• New Row (Custom Query) (Polling) - Triggers when new rows are returned from a custom query that you provide.
• New or Updated Row (Polling) - Triggers when a new row is added or modified.
• New Row (Polling) - Triggers when you add a new row.
• New Table (Polling) - Triggers when you add a new table.

Searches

• Find Row via Custom Query - Finds a row in a table via a custom query you control.
• Find Row - Finds a row in a table via a lookup column.

Actions

• Update Row - Updates an existing row.
• New Row - Adds a new row.

Limitations

• Database must be accessible from Zapier's static IP address (54.86.9.50). Connections from localhost (127.0.0.1) are not supported.
• Database queries must complete within 30 seconds or they will timeout.
• The "New Row" trigger only sees the most recent 50 items, limiting the maximum number of rows a workflow can trigger on at one time.
• Tables must have primary keys for proper deduplication; if no primary key exists, Zapier will attempt to guess using columns with "id" in the name.
• Database must be configured to accept remote connections and cannot be bound only to localhost (127.0.0.1) - must be accessible from public interfaces.
• Special network, server, and SQL server permissions are required to allow Zapier connections.
• For cloud hosting (AWS RDS/EC2, Google Cloud SQL), specific firewall and security group configurations are required to allow access from Zapier's IP address. Learn more in our troubleshooting connections to your database.

Templates

View all of MySQL's templates.

Use cases

• 6 ways to automate MySQL
• 5 ways to automate your database apps with Zapier

Additional MySQL resources

• Zapier's MySQL integration page
• MySQL's Help Center
• MySQL's API documentation