Encrypted Login/Logout using Node-RED via MySQL

Dashboard
1

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

image
image764×280 58.1 KB

2

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

3

I found this syntax

PASSWORD( string_to_encrypt )

but i don't know how to use

4

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?

5

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

6

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

7

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

thank you

8

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