Jump to content
Sign in to follow this  
Worldofjimmy

SQL How is the password encrypted in MYSQL?

Recommended Posts

Im building a Node.JS web application and trying to fix the login authentication.

Currently looking at the mysql database and can see SALT and Password.

 

How is the password being hashed?

Password+Salt?

 

 

 

Share this post


Link to post
Share on other sites
On 6/8/2019 at 6:51 PM, jcsnider said:

Thank you jcsnider for explanation of encryption of password mysql.

 

I managed to create the login logic for my Node.JS web application.

 

Now I'm trying to figure out the sign up logic.

How is the Id for new accounts produced? Is there any formula?

I can see that pattern is 8 characters + dash + 4 characters + dash + 4 characters + dash + 4 characters + dash + 12 characters = 36 characters

 

02a7eeee-1690-4655-80df-0e85997b39ce

08d68361-e3f6-7d0e-ec60-a7f51dcc60c5

25d7cd34-ccb2-4940-a1ff-e0de09b0ad46

904867dc-54ab-40c2-a5e5-7b5503168e85

ae77bfb0-e049-4bf3-b810-ffcdf59dae8f

 

If I do not follow this kind of pattern, would the new accounts be unaccessible in the game?

 

Link is my login logic (sorry for poor code, this is learn by doing)

login.logic.rtf

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...