how to use MD5?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

how to use MD5?

Post 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
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post 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
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

how do i do that? :oops:
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post by infolock »

malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

thanx

read and bookmarked

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