I already found a solution to my own question. The issues I had: 1. In HeidiSQL, the user created is not linked to ctrlX IP address. 2. In ctrlX Node-RED MySQL node, the database is not pointed to where the database was located. So I did this instead: - Inside HeidiSQL Query: CREATE USER 'ctrlxCore'@'192.168.0.234' IDENTIFIED BY 'password'; Where 192.168.0.234 is my ctrlX Core device - Inside Node-RED MySQL database node: Host: 192.168.0.132 (my computer IP where database was created/installed) port: 3306 user: ctrlxCore password: password database: ctrlx Charset: UTF8 In HeidiSQL, I dropped the previously created TABLES and created a new and simple TABLE to get values from mqtt-in node: CREATE TABLE humidity ( VALUE VARCHAR(100), TIMESTAMP timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE ); You can refer to my Node-RED flow as per attached screenshots. Thank you
... View more