Node-RED node to read and write to a MySQL or a MariaDB database. It uses TLS (SSL) encryption and is compatible with "Caching SHA2 password" authentication method (MySQL >= 8).
{ "mysql": { "host": "mysql_host", "user": "mysql_username", "password": "mysql_passord", "database": "mysql_database", "ssl": { "rejectUnauthorized": false ...