23 Dec
2008
23 Dec
'08
8:57 p.m.
I'm enabling digest-md5 authentication with "user@example.com" username and plain-text passwords stored in a MySQL database. What should the password field contain in order to work with digest-md5? Would the following:
SELECT CONCAT('{digest-md5}', MD5(CONCAT(username, '::', password))) AS password ...
be correct?