# Mysql node not working properly

**URL:** https://discourse.nodered.org/t/mysql-node-not-working-properly/28746
**Category:** General
**Created:** [22 June 2020 18:22 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746 "2020-06-22T18:22:31Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![jnbest00](https://avatars.discourse-cdn.com/v4/letter/j/9f8e36/32.png) [@jnbest00](https://discourse.nodered.org/u/jnbest00)
#### Post date: [22 June 2020 18:22 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746/1 "2020-06-22T18:22:31Z")

</div>

Hello, Im trying to connect to a MySQL database via the node-red-node-mysql. After I enter the appropriate info it reads back an error msg 'Error: Cannot find module './protocol/constants/client'. Does anyone know a solution to fix this problem?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/b/7b412fc95c3df255d935fb0227ce190b36466c9e.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: [22 June 2020 19:10 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746/2 "2020-06-22T19:10:26Z")

</div>

- what platform is NR running on?
- what version of NR and node.js? (look at the NR startup log)
- is the mysql server on the same device as NR?
- from a CLI, can you access mySQL?
- have you configured the mysql node?

---

<div class="post-metadata">

### Author: ![jnbest00](https://avatars.discourse-cdn.com/v4/letter/j/9f8e36/32.png) [@jnbest00](https://discourse.nodered.org/u/jnbest00)
#### Post date: [22 June 2020 21:42 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746/3 "2020-06-22T21:42:51Z")

</div>

The NR is running on the MultitConnect Conduit AEP. The NR version is v0.15.3 and yes the my sql sever is on the same device as node red. The node is configured and I can access the server through the command line.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [22 June 2020 22:08 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746/4 "2020-06-22T22:08:39Z")

</div>

I suspect that we may end up out of luck. That is indeed a very old version - so we may have to try to find a mysql node version of similar vintage - you may have to try several and even then we may be out of luck (not to mention any bugs that may have in them that have since been fixed)... I would maybe start somewhere around node-red-node-mysql@0.0.15 and see if that works. If so then try newer until it fails - if not work backwards.

---

<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: [21 August 2020 22:08 UTC](https://discourse.nodered.org/t/mysql-node-not-working-properly/28746/5 "2020-08-21T22:08:46Z")

</div>

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