MySQL

MySQL is an open source relational database management system used to store data of different types which can be queried using Structured Query Language (SQL). Relational database means tables can be cross-referenced with each other. For more information on MySQL, see the company website.

In the context of Nintex Automation Cloud, MySQL is a connector A software component that allows seamless integration with third-party services, business applications, and content stores. Examples include Salesforce, Box, and Microsoft SharePoint. Connectors are used to create connections required for workflow actions and start events. used to create connections for MySQL actions. Use the MySQL actions to execute queries in your database.

Create a MySQL connection

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

Create a connection from the connections page or from the action configuration panel when configuring the action. For information about creating connections and assigning permissions, see Manage connections.

In the Add a new connection section, complete the fields as follows:

In this field	Select or enter the following
Connection name	A user-friendly name for your new connection
Username	Username with access to the SQL server.
Password	Password for above username.
Database Host	SQL server on which the database resides. For example: yourDBhost.mysql.database.com. You can use "," or ":" to specify the port.
Database Name	Name of the database.