Node-RED: Connecting to a MySQL or MariaDB database

This documentation is part of the Getting started guide. View the full guide here: How to get started with Node-RED.

Welcome to the Stackhero documentation

Stackhero provides a fully managed Node-RED cloud environment designed to get you building workflows quickly:

  • Built-in MQTT server (Mosquitto) for seamless IoT integration.
  • Full access to the Node-RED admin UI for managing flows and settings.
  • Node-RED Dashboard included for real-time visualization.
  • Dedicated SMTP email server included, with no limits on sending.
  • Effortless one-click updates to keep your instance current.
  • Custom domain names with automatic HTTPS: for example, https://node-red.your-company.com.
  • High performance and strong security with private, dedicated infrastructure.

You can have a secure, production-ready Node-RED cloud hosting instance running in about 5 minutes. Stackhero handles setup, updates, and infrastructure so you can focus on building automations.

We have developed a node to connect to a MySQL server that is fully compatible with MySQL 8's new authentication system, "Caching SHA2 Password", as well as with MariaDB.

MySQL/MariaDB nodeMySQL/MariaDB node

For more details, visit the official repository. To install this node on your Node-RED instance, simply search for stackhero in the Manage palette section of your Node-RED dashboard.