# MySQL connection Error

**URL:** <https://discourse.nodered.org/t/mysql-connection-error/20953>\
**Category:** General\
**Created:** [28 January 2020 10:40 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953 "2020-01-28T10:40:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Avipur](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@Avipur](https://discourse.nodered.org/u/Avipur)\
**Post date:** [28 January 2020 10:40 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/1 "2020-01-28T10:40:38Z")

</div>

Hi All,

I am beginner to Node Red . I am trying to connect MySQL database using "node-red-node-mysql" through a simple MySQL Query . I am getting following error

Error: ER\_NOT\_SUPPORTED\_AUTH\_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

MySQL version is 8.0  
Node Red Node-RED version: v1.0.3  
Node.js version: v12.13.1

The MySQL Node Settings are as follows

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

Please help In case anybody has come across this issue and solved .

Thanks in Advance.

---

<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:** [28 January 2020 10:58 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/2 "2020-01-28T10:58:18Z")

</div>

Looks like version 8 is not currently supported (see: [https://github.com/node-red/node-red-nodes/issues/534](https://github.com/node-red/node-red-nodes/issues/534))

---

<div class="post-metadata">

**Author:** ![Bobo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobo/32/8401_2.png) [@Bobo](https://discourse.nodered.org/u/Bobo)\
**Post date:** [28 January 2020 11:39 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/3 "2020-01-28T11:39:51Z")

</div>

Not sure if this is a solution for you but I get the same error with Mariadb.

Doing a **"grant all privileges** on mydb.\* to myuser identified by 'mypassword';" solved it for me.

---

<div class="post-metadata">

**Author:** ![Avipur](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@Avipur](https://discourse.nodered.org/u/Avipur)\
**Post date:** [28 January 2020 12:21 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/4 "2020-01-28T12:21:29Z")

</div>

Thanks for your response.

I just found the solution on MySql forum and it is working with version 8.0

The solution is as follows

Execute the following query in MYSQL Workbench

`ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'`

Where `root` as your user `localhost` as your URL and `password` as your password

Then run this query to refresh privileges:

`flush privileges;`

---

<div class="post-metadata">

**Author:** ![Avipur](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@Avipur](https://discourse.nodered.org/u/Avipur)\
**Post date:** [28 January 2020 12:23 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/5 "2020-01-28T12:23:54Z")

</div>

Thanks for your response. I could solve this issue by following solution provided on MySQl forum.  
The Solution is as follows  
Execute the following query in MYSQL Workbench

`ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'`

Where `root` as your user `localhost` as your URL and `password` as your password

Then run this query to refresh privileges:

`flush privileges;`

---

<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:** [28 March 2020 12:23 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953/6 "2020-03-28T12:23:58Z")

</div>

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