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 ready-to-use Node-RED cloud solution that provides a host of benefits, including:

  • MQTT server included (Mosquitto).
  • Full access to Node-RED admin UI.
  • Node-RED Dashboard included.
  • Unlimited and dedicated SMTP email server included.
  • Effortless updates with just a click.
  • Customisable domain name secured with HTTPS (for example, https://node-red.your-company.com).
  • Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's Node-RED cloud hosting solution!

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.

Continue reading this guide

  1. Read the full guide: Getting Started
    How to Get Started with Node-RED
  2. How to Send Email Notifications
  3. How to Require Node.js Native Modules
  4. Connecting to an InfluxDB v2 Database
  5. How to Catch and Log Errors from Node-RED Nodes
  6. Store Data on the Filesystem
  7. Use an HTTP Node with an iFrame
  8. Safe Mode: Resolve Node-RED Flows Errors (502 Error)
  9. Node Version in Palette Manager is Older Compared to the NPM One
  10. Handle Error "SSL routines:ssl3_get_record:wrong version number:../deps/openssl/openssl/ssl/record/ssl3_record.c"

Other articles for Node-RED

  1. Introduction
    Introduction to Node-RED, everything you need to know about it
  2. Automate with the CLI
    Start Node-RED, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI
  3. Use case: connect mailboxes
    Seamlessly connect hundreds of mailboxes in a post office
  4. MQTT server
    How to connect Node-RED to the Mosquitto MQTT server
  5. Manage projects
    How to use "Projects" in Node-RED