Skip to main content

MySQL Adaptor

About MySQL​

MySQL is a free and open-source relational database management system. It can be accessed and manipulated using SQL to extract or load data.

Integration Options​

The mysql adaptor provides direct database connections for accessing data and executing SQL and standard database operations. See functions for more on how to use this adaptor.

Authentication​

See the MySQL docs for the latest on supported authentication methods. When integrating with a MySQL database via OpenFn, you authenticate via SSH using authorized database credentials. See this adaptor's configuration docs for more on the required authentication parameters.

See platform docs on managing credentials for how to configure a credential in OpenFn. If working locally or if using a Raw JSON credential type, then your configuration will look something like this:

{
  "host": "some-host-url.compute-1.amazonaws.com",
  "database": "demo-db",
  "user": "admin-demo",
  "password": "@super(!)Secretpass"
}
  1. MySQL documentation

I've noticed a problem with this Adaptor, or something is out of date, what can I do?​

Thanks for asking! We are a fully Open Source Digital Public Good, and we welcome contributions from our community. Check out our Adaptors Wiki for more information on how you can update Adaptors!

Or, you can always reach out to the Community through our Community Forum here.