# How to export flows.json with MySQL's user and password?

**URL:** <https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751>\
**Category:** General\
**Created:** [26 January 2021 06:18 UTC](https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751 "2021-01-26T06:18:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChiaChia1114](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chiachia1114/32/35545_2.png) [@ChiaChia1114](https://discourse.nodered.org/u/ChiaChia1114)\
**Post date:** [26 January 2021 06:18 UTC](https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751/1 "2021-01-26T06:18:06Z")

</div>

Hi, exeryone.  
I have a question about export MySQL's flows.json. When I set all of the config of the node of the MySQL, I export the node's flow.json file. But why can't I export the user and password with json file? There are only host, port, database, timezone, charset and name in my flow.json. Does anybody can tell me how to export MySQL's config of the user and password?

My configuration  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/9/c9c4cf4d6381333aac04acb2973a46afffc53ecf.png)

Export node's flows.json

> [{"id":"263ac966.f57786","type":"mysql","z":"85f8dd75.c32f5","mydb":"a844720c.608d6","name":"","x":690,"y":200,"wires":[["56e91397.4878dc"]]},{"id":"a844720c.608d6","type":"MySQLdatabase","name":"mysql","host":"127.0.0.1","port":"3306","db":"my\_db","tz":"","charset":""}]

Hope guys can help me. Thanks a lot ~~

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [26 January 2021 07:09 UTC](https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751/2 "2021-01-26T07:09:37Z")

</div>

Credentials live seperately in flows\_cred.json.

---

<div class="post-metadata">

**Author:** ![ChiaChia1114](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chiachia1114/32/35545_2.png) [@ChiaChia1114](https://discourse.nodered.org/u/ChiaChia1114)\
**Post date:** [27 January 2021 05:48 UTC](https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751/3 "2021-01-27T05:48:39Z")

</div>

Thanks a lot ~~ It works.

---

<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:** [10 February 2021 05:49 UTC](https://discourse.nodered.org/t/how-to-export-flows-json-with-mysqls-user-and-password/39751/4 "2021-02-10T05:49:37Z")

</div>

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