MySQL Connector

[#1]

Note on third‑party tools

We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.

Query and manage data in a MySQL Database

Connections

MySQL Connection

Authenticate requests to a MySQL server

Create a new MySQL connection and enter the host, port, and database for your MySQL server.
The username and password are optional inputs that can be put directly into a MySQL connection.

Input	Comments	Default
Host	The publicly-accessible address of your MySQL server.	my-server.example.com
Port	The port your database server is exposing.	3306
Database	The name of your database.
Username
Password

Actions

Query

Returns the results of a MySQL database query

Input	Comments	Default
Query	A query to be executed by the MySQL server. Substitute parameters with '?' marks.	SELECT * FROM table WHERE name = ? AND age > ?
Parameters	Optional parameters to insert into a query. Use this when you know how many parameters your query uses ahead of time. Use either parameters or reference parameters, not both.
Reference Parameters	Optional parameters to insert into a query. Use this when you don't know how many parameters your query uses ahead of time. Reference parameters from a previous step that returns an array. Use either parameters or reference parameters, not both.
Connection