# Encrypted Login/Logout using Node-RED via MySQL

**URL:** <https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306>\
**Category:** Dashboard\
**Created:** [17 June 2021 15:28 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306 "2021-06-17T15:28:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![grandautism](https://avatars.discourse-cdn.com/v4/letter/g/b5ac83/32.png) [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Post date:** [17 June 2021 15:28 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/1 "2021-06-17T15:28:40Z")

</div>

hello everyone  
i want to know how to crypt pasword in mySQL like showing the photo  
thank you

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/1/41278ee2d82b47a6a79ad1f09085cefba121cff1.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:** [17 June 2021 17:09 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/2 "2021-06-17T17:09:27Z")

</div>

Have you done a google search? try using `mysql how to encrypt password` and you will find many explanations.

---

<div class="post-metadata">

**Author:** ![grandautism](https://avatars.discourse-cdn.com/v4/letter/g/b5ac83/32.png) [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Post date:** [18 June 2021 09:06 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/3 "2021-06-18T09:06:57Z")

</div>

I found this syntax

> PASSWORD( string\_to\_encrypt )

but i don't know how to use

---

<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:** [18 June 2021 10:11 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/4 "2021-06-18T10:11:08Z")

</div>

Can you explain a bit more about what you are trying to do?  
Where are you trying to encrypt the password and for what reason?

---

<div class="post-metadata">

**Author:** ![grandautism](https://avatars.discourse-cdn.com/v4/letter/g/b5ac83/32.png) [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Post date:** [18 June 2021 10:42 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/5 "2021-06-18T10:42:01Z")

</div>

for my dashboard i am trying to login and log out via MySQL  
in my database i created a table for users, which contains username name, profile, password ... i want to secure usernames and passwords, I want to encrypt them

---

<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:** [18 June 2021 11:30 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/6 "2021-06-18T11:30:30Z")

</div>

Are you trying to secure user access to MySQL or to the node-red dashboard?

If you are tryng to secure access to MySQL then this is not a Node-RED issue and you should read up on MySQl and/or talk to your DBA (if this is in a work environment). Here is a link to information about password hashing in MySQL: [MySQL :: MySQL 5.6 Reference Manual :: 6.1.2.4 Password Hashing in MySQL](https://dev.mysql.com/doc/refman/5.6/en/password-hashing.html)

---

<div class="post-metadata">

**Author:** ![grandautism](https://avatars.discourse-cdn.com/v4/letter/g/b5ac83/32.png) [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Post date:** [18 June 2021 14:02 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/7 "2021-06-18T14:02:23Z")

</div>

> [@zenofmud](#):
>
> is

I wanted to create my table SQL using node red, but you are right, i found this tuto

[![](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/0/70987e953158647ee04c26899841c53ff61f33fc.jpeg "Learning MySQL- Encryption, Hashing, and Compressing") ](https://www.youtube.com/watch?v=hptvnLOxpJY)

thank you

---

<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:** [18 July 2021 14:02 UTC](https://discourse.nodered.org/t/encrypted-login-logout-using-node-red-via-mysql/47306/8 "2021-07-18T14:02:23Z")

</div>

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