Loading
HelpMySQL

How to Get Started with MySQL

Last updated:

About MySQL's Integration

What kind of authentication does MySQL use?

MySQL uses a custom authentication.

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.

Do I need special account permissions in MySQL to use MySQL with Zapier?

You must allow Zapier to connect in:

  • Network
  • Server
  • SQL server

Are custom fields in MySQL supported when I use MySQL with Zapier?

Yes, custom fields are supported.

Connecting with MySQL

When connecting a new MySQL account, you'll see the following fields:

Connect Fields

Host: This is the IP address or hostname (db.example.com) of your database instance. It must be accessible from outside your network. Zapier will send database connections from three IP address.

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 limited permission scope.

Password: This is the password for the account associated with the user name.

SSL Client Certificate and SSL Private Key: These are fields you can use if you'd like to use MySQL certificate authorization instead of username/password authorization. You'll still need to provide a username since the field is required.

Note

Although all fields are stored encrypted in our database, you should not connect a production database to Zapier. You should create an intermediary database to connect with Zapier, then send data back to your main production database.


Need more help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community

Zapier University

Video courses designed to help you become a better Zapier user, whether you’re a beginner or more experienced.
View courses