Page 1 of 1

how to use MD5?

Posted: Sun Dec 14, 2003 1:06 pm
by malcolmboston
really noobie question i know

in mysql how do you turn a column into a MD5 hashed column for example password (<--obviously) i know how to extract it from PHP but dont know how to create one in MySQL

my password column is currently plain text, ive searched through fieldtype, varchar etc its not there, i can view what a 'item' will look like when MD5'd but thats as far as it goes

Cheers

Posted: Sun Dec 14, 2003 1:38 pm
by delorian
Hmmm, char(32) would be fine for md5 hashed passwords, of course if you insert them into your base already hashed in php script. :D

Posted: Sun Dec 14, 2003 1:39 pm
by malcolmboston
how do i do that? :oops:

Posted: Sun Dec 14, 2003 2:14 pm
by infolock

Posted: Mon Dec 15, 2003 3:01 am
by malcolmboston
thanx

read and bookmarked

note to self : seemingly complex things are always very simple, remember this