Node-RED: Connecting to a MySQL or MariaDB Database

This documentation is part of the Getting Started guide. You can view the complete guide here: How to Get Started with Node-RED.

Welcome to the Stackhero documentation

Stackhero offers a fully managed Node-RED cloud environment designed to help you build workflows quickly:

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

You can have a secure, production-ready Node-RED cloud hosting instance up and running in about 5 minutes. Stackhero takes care of installation, updates, and infrastructure so you can focus on building your 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.