MySQL

MySQL

Article Type: Reference Audience: Developers, IT Module: Edge

MySQL is a widely used open-source relational database management system (RDBMS). It stores and manages data in structured tables with rows and columns, supports the SQL language for querying and manipulating data, and is a common backend for web and enterprise applications. The Edge Gateway can connect to a MySQL database to read and write data as part of a Data Flow.

Connector type: Edge data connector — configured on the Edge Gateway to connect to a database (no physical device driver required).

Configuration

  • Server: The host name of the SQL server.
  • Port: The port the SQL server is running on. Typically 3306.
  • Database: The database to connect to.
  • User: The user to connect to the server as.
  • Password: The password for the connecting user.
  • Options: A JSON object for extra connection options.

Functions

Query

Executes SQL against a database.

  • Query: The SQL to run against the database. The string can be parameterized with ?.
  • Parameters: The parameter values to be merged into the SQL to execute (an array of values).

See Also

    • Related Articles

    • Edge Gateway System Requirements & Deployment Best Practices

      Article Type: Concept / How-To Audience: Solution Architects, OT/IT Engineers, Administrators Module: Fuuz Edge Gateway Applies to Versions: 2025.12+ Overview The Edge Gateway acts as a secure door between your facility and Fuuz Cloud. It is not a ...

    • IBM DB2 SQL

      Article Type: Reference Audience: Developers, IT Module: Edge IBM DB2 is a family of data management products, including database servers, developed by IBM. It is a powerful and versatile relational database management system (RDBMS) commonly used in ...

    • Microsoft SQL

      Article Type: Reference Audience: Developers, IT Module: Edge Microsoft SQL, often referred to as Microsoft SQL Server, is a relational database management system (RDBMS) developed by Microsoft. It is one of the leading database management systems in ...

    • Oracle SQL

      Article Type: Reference Audience: Developers, IT Module: Edge Oracle SQL, often referred to simply as Oracle, is a powerful and widely used relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most popular ...

    • Cloud Connectors - Complete Reference Guide

      Article Type: Reference Audience: Solution Architects, Enterprise Administrators, Integration Specialists, Partners Module: Cloud Connectivity & Integration Applies to Versions: Fuuz 2026.2+ 1. Overview Every cloud, SaaS, and enterprise business ...