# MYSQL - Some connect and some don't

**URL:** <https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931>\
**Category:** General\
**Created:** [13 February 2021 12:55 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931 "2021-02-13T12:55:03Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 12:55 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/1 "2021-02-13T12:55:03Z")

</div>

Hi,

I have a flow where I quarry a db in AWS, all my data are in the same db but different tables.

I had to reset my password and now not all the node-red-node-mysql nodes connect to the db.

They are either "OK" or just blank, although all there configurations are the same.

Any ideas please.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/4/a4a0f1b55d2f0634ee04d5b7ba14d5ed1247ecc6.png)

---

<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:** [13 February 2021 13:32 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/2 "2021-02-13T13:32:51Z")

</div>

> [@ScheepersJohan](#):
>
> node-red-node-mysql

In the mysql nodes are they all using the same database config node (so only one entry in the Database dropdown?

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/2/924e1f3e54bd6eaa0295624efd6fe8aeab08432d.png)

---

<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:** [13 February 2021 13:33 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/3 "2021-02-13T13:33:12Z")

</div>

How many configurations are seen when you select the drop-down? (There should only be one)

Have you restarted node-red to reinitialise connections?

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 13:35 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/4 "2021-02-13T13:35:46Z")

</div>

Hi,

There is more than one but they are all set on the same one.

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 13:36 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/5 "2021-02-13T13:36:22Z")

</div>

I have reboot my EC2 instance as well.

---

<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:** [13 February 2021 13:37 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/6 "2021-02-13T13:37:14Z")

</div>

That isn't what you are supposed to do. Use one config for all. Delete the rest.

---

<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:** [13 February 2021 13:38 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/7 "2021-02-13T13:38:03Z")

</div>

Are there other ones to the same database? If so then delete them (in hamburger menu Configuration Nodes).

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 13:44 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/8 "2021-02-13T13:44:49Z")

</div>

I have deleted the other two.

Restarted my follows, still some not connecting.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/1/c11a656ddcab29bf89df06b16d0e5f75425acc18.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/1/91acc9c57be591d2c88f14a0d0052eb0794f40cd.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [13 February 2021 17:21 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/9 "2021-02-13T17:21:00Z")

</div>

Have you tried stop/starting node-red?

---

<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:** [13 February 2021 17:24 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/10 "2021-02-13T17:24:02Z")

</div>

> [@ScheepersJohan](#):
>
> Restarted my follows, still some not connecting

Have the nodes ran? Some don't update status till a msg has passed through. Use debug nodes before and after mysql nodes to confirm.

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 19:55 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/11 "2021-02-13T19:55:14Z")

</div>

Were all working perfectly until I changed the password.

Have put debug, before and after (this were my first step to fault find) correct topic in, but not connecting and not passing quarry out.

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 19:56 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/12 "2021-02-13T19:56:05Z")

</div>

Restarted it several times.

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 19:59 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/13 "2021-02-13T19:59:18Z")

</div>

Here you can see even the node reports all good, but the data are not written to the db.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/4/b47deafd519bda3901349b92a18d21febfae8138.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/6/a68205893ad6af876665fdd07fd4a9e6c9c501cc.png)

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [13 February 2021 20:54 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/14 "2021-02-13T20:54:57Z")

</div>

I have deleted the 3 flows that manages the display of the data, now the data are written to the db, so I will leave it for 12 hours and see if it's stable.

What is the max connections that you can make to a db with the node-red-node-mysql?

---

<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:** [14 April 2021 20:55 UTC](https://discourse.nodered.org/t/mysql-some-connect-and-some-dont/40931/15 "2021-04-14T20:55:00Z")

</div>

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