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 Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. 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
|A user-friendly name for your new connection
Username with access to the SQL server.
Password for above username.
|SQL server on which the database resides. For example: yourDBhost.mysql.database.com. You can use "," or ":" to specify the port.
Name of the database.
For instructions on SQL Server firewall configuration, see the Configure the Windows Firewall to Allow SQL Server AccessMicrosoft article or, for SQL Server on Windows Azure, see the Creating Microsoft SQL Server Connection to SQL Azure from Nintex Automation CloudNintex Community article.
See also Allowlist IP addresses for references to the IP addresses that you may need to allowlist in your firewalls and networking devices to enable communications with Nintex Automation Cloud.