# Send data from topic in MQTT broker to database (phpmyadmin)

**URL:** <https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376>\
**Category:** General\
**Created:** [10 January 2022 07:02 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376 "2022-01-10T07:02:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![faridomu](https://avatars.discourse-cdn.com/v4/letter/f/c89c15/32.png) [@faridomu](https://discourse.nodered.org/u/faridomu)\
**Post date:** [10 January 2022 07:02 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/1 "2022-01-10T07:02:07Z")

</div>

Hello everyone  
I'm very new to this. I want to send data IR sensor from MQTT Broker to my database in phpmyadmin in node-red.  
I already send the data sensor to topic that published to mqtt broker, and i can't send it from mqtt broker to database.  
Is there any solution for this? or any example for this project?  
thank you

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 January 2022 08:14 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/2 "2022-01-10T08:14:35Z")

</div>

> [@faridomu](#):
>
> database in phpmyadmin

What do you mean by a database in phpmyadmin?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [10 January 2022 08:28 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/3 "2022-01-10T08:28:44Z")

</div>

I suspect you mean write data to a mysql or mariadb database?

Install `node-red-node-mysql` and read the nodes help info written in the online readme and in the nodes built in help on the sidebar.

Lastly, search this forum for 'mysql' - there are many many threads on this subject.

If you get stuck, come back with more specific issue and details like what version of node, what version of node-red and screenshots / flow exports so we can further help you.

---

<div class="post-metadata">

**Author:** ![faridomu](https://avatars.discourse-cdn.com/v4/letter/f/c89c15/32.png) [@faridomu](https://discourse.nodered.org/u/faridomu)\
**Post date:** [10 January 2022 14:07 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/4 "2022-01-10T14:07:59Z")

</div>

Sorry I mean store data from mqtt broker to mariadb 😃

---

<div class="post-metadata">

**Author:** ![faridomu](https://avatars.discourse-cdn.com/v4/letter/f/c89c15/32.png) [@faridomu](https://discourse.nodered.org/u/faridomu)\
**Post date:** [10 January 2022 14:09 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/5 "2022-01-10T14:09:19Z")

</div>

Thank you for the solution! 😃  
i will ask again if i got stuck

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [11 March 2022 14:10 UTC](https://discourse.nodered.org/t/send-data-from-topic-in-mqtt-broker-to-database-phpmyadmin/56376/6 "2022-03-11T14:10:09Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.