469,336 Members | 6,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

Passwords

I want to store some passwords in a MySQL table. Is there any way of
preventing someone using say COntrolcentre from viewing the passwords.
Aug 1 '05 #1
1 1601
Paradigm wrote:
I want to store some passwords in a MySQL table. Is there any way of
preventing someone using say COntrolcentre from viewing the passwords.


You could restrict the privileges on that table. But if they have your
superuser password for your MySQL server, they can do anything anyway.

You should never store plaintext passwords in a database; store an MD5()
hash of the password, and when you need to validate a user's input
matches the password, check that MD5() of their input matches what's in
the database. This technique protects password privacy much better,
because it means no one can steal the original password string out of
the database -- not even you -- because it's not stored.

Regards,
Bill K.
Aug 4 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Florian Lindner | last post: by
1 post views Thread by Shapper | last post: by
15 posts views Thread by Dino Vliet | last post: by
3 posts views Thread by Jeremy Deuel | last post: by
5 posts views Thread by Macca | last post: by
19 posts views Thread by Cord-Heinrich Pahlmann | last post: by
2 posts views Thread by Simon.Whiteside | last post: by
3 posts views Thread by Eric Wertman | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.