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 visualisation.
• Dedicated SMTP email server included, with no sending limits.
• Effortless one-click updates to 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 running in around 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 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.