Encrypt Passwords in MySQL to access and decrypt in GUI

Hello! I was wondering if anyone could help me out?

I'm trying to work on this particular component of my project for a class and not sure how to make it happen or if it is possible.

What I want to do is:
I have a database locally hosted using xampp. I created a table with 'Username' and 'Password' and my program the first part is a Login GUI it accesses the information to see if your login information is there and if it is, it logins and opens the next GUI. However, I don't know how to encrypt the passwords and then decrypt them on the program end. At this point, they're just plain text username and passwords.

It isn't the most vital to my program that it encrypts passwords as this is for a class project and the user info is created by me before hand anyways but I think it'd be cool and would add to the complexity of the program and therefore my grade.

I'm not an experienced Java coder.
Any help would be appreciated :)!

Quote:

---

Originally Posted by SomeAsianDude

Hello! I was wondering if anyone could help me out?

I'm trying to work on this particular component of my project for a class and not sure how to make it happen or if it is possible.

What I want to do is:
I have a database locally hosted using xampp. I created a table with 'Username' and 'Password' and my program the first part is a Login GUI it accesses the information to see if your login information is there and if it is, it logins and opens the next GUI. However, I don't know how to encrypt the passwords and then decrypt them on the program end. At this point, they're just plain text username and passwords.

It isn't the most vital to my program that it encrypts passwords as this is for a class project and the user info is created by me before hand anyways but I think it'd be cool and would add to the complexity of the program and therefore my grade.

I'm not an experienced Java coder.
Any help would be appreciated :)!

---

For ussual you dont do save it "encrypted", you better dont save the password
what u should save is, a hash which makes sure the password is correct. (For example md5 base64 encoded string)
To make it more difficult to reproduce it, you save it with "salt & pepper"
for example you save also the timestamp when he set the password, (or his create date or whatever, you only must make sure you can access it any time)
and some static string
like

Code:

---

function getHash(string password, DWORD timestamp): string;
begin
        result := base64_encode(md5(password + toString(timestamp) + 'my Pepper String'));
end;

---

then u save the hash + timestamp to database, then on login, you fetch from database the timestamp + the hash, create the hash with the timestamp and the password the user have insert and compare it against your hash

You typically do not encrypt or store passwords. You take the password from the user an hash it with another character as a salt. You store the hashed version and the salt. Then when they go to log in you rehash their Input with the same hashing algoritm and the same salt. The salt is typically unique for the user I�d.

So

Password
Password + salt
Hash(password + salt)
Store: hash , salt

Then
Select * from id where user = user and hash = hash(password + salt)