# ER\_NOT\_SUPPORTED\_AUTH\_MODE

**URL:** <https://discourse.nodered.org/t/er-not-supported-auth-mode/5465>\
**Category:** General\
**Created:** [4 December 2018 07:33 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465 "2018-12-04T07:33:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![zayas](https://avatars.discourse-cdn.com/v4/letter/z/d2c977/32.png) [@zayas](https://discourse.nodered.org/u/zayas)\
**Post date:** [4 December 2018 07:33 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/1 "2018-12-04T07:33:11Z")

</div>

Hello, I have the following problem, I want to connect with the node network to an external database, that is to say with a different IP but of the same range.  
In the MySQL-Worbench program, everything is well configured and connected to the MySQL-Server. The problem is when I transfer the data from the node-red to MySQL.  
Note: The users have all the privileges.  
The problem is the following: "Error: ER\_NOT\_SUPPORTED\_AUTH\_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client"!

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 December 2018 07:50 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/2 "2018-12-04T07:50:43Z")

</div>

so what MySQL server are you running?

---

<div class="post-metadata">

**Author:** ![zayas](https://avatars.discourse-cdn.com/v4/letter/z/d2c977/32.png) [@zayas](https://discourse.nodered.org/u/zayas)\
**Post date:** [4 December 2018 08:24 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/3 "2018-12-04T08:24:14Z")

</div>

MysQL Server

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 December 2018 08:32 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/4 "2018-12-04T08:32:04Z")

</div>

so what version?

---

<div class="post-metadata">

**Author:** ![zayas](https://avatars.discourse-cdn.com/v4/letter/z/d2c977/32.png) [@zayas](https://discourse.nodered.org/u/zayas)\
**Post date:** [4 December 2018 09:34 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/5 "2018-12-04T09:34:34Z")

</div>

8.0, the last

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 December 2018 10:00 UTC](https://discourse.nodered.org/t/er-not-supported-auth-mode/5465/6 "2018-12-04T10:00:26Z")

</div>

You haven't mentioned which of the SQL nodes you are using.

But if you google that error code and node.js you see that there are lots of posts about it.  
Most recent ones appear to be with people using the MySQL user name 'root" if you are have you tried using a different username?

Otherwise, have you made sure you are on the latest versions of Node-RED and the SQL node?

If none of those work, then you will need to configure your MySQL server to allow a different access method.