# Node-Red & MySql connection failed ( authentication protocol )

**URL:** <https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603>\
**Category:** General\
**Created:** [30 March 2019 09:48 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603 "2019-03-30T09:48:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![BartosIstvan](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@BartosIstvan](https://discourse.nodered.org/u/BartosIstvan)\
**Post date:** [30 March 2019 09:48 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/1 "2019-03-30T09:48:36Z")

</div>

Hi everyone! At first, I have a Simatic IOT2040 on which is running the Node-Red server. I want to make a MySql connection with my localhost server from my PC. To be able to access my external database, I have created a new user granting all privileges ( CREATE USER 'monty'@'%' IDENTIFIED BY '';  
GRANT ALL PRIVILEGES ON **.** TO 'monty'@'%' WITH GRANT OPTION; ).  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/a68bf200597c4a5426b3afd29e5424103f4f5a03.png)  
The host which I use is my Ip-adress of my Pc on which is running the server. But almost I cant connect to my DB.  
 ![errormsg](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/d/d88559c5eee0412fb3969703023d69e9e21aef25.png)  
I know this is a MySql issue, but if somebody knows the solution please share with me. 😃  
I tried to figure out how to upgrade my MySql client, but I did not find anything useful.

---

<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:** [30 March 2019 10:17 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/2 "2019-03-30T10:17:15Z")

</div>

google: ER\_NOT\_SUPPORTED\_AUTH\_MODE

Your database is not setup to login without a password.

---

<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:** [30 March 2019 10:19 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/3 "2019-03-30T10:19:50Z")

</div>

Try

```auto
ALTER USER 'monty'@'%' IDENTIFIED WITH mysql_native_password BY 'thepassword';

```

---

<div class="post-metadata">

**Author:** ![BartosIstvan](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@BartosIstvan](https://discourse.nodered.org/u/BartosIstvan)\
**Post date:** [30 March 2019 10:30 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/4 "2019-03-30T10:30:41Z")

</div>

Thank you very much . It works now.

---

<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:** [30 March 2019 10:55 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/5 "2019-03-30T10:55:54Z")

</div>

Which solution worked?

---

<div class="post-metadata">

**Author:** ![BartosIstvan](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@BartosIstvan](https://discourse.nodered.org/u/BartosIstvan)\
**Post date:** [30 March 2019 11:23 UTC](https://discourse.nodered.org/t/node-red-mysql-connection-failed-authentication-protocol/9603/6 "2019-03-30T11:23:18Z")

</div>

I had to add a password for the db user! Thanks again !