On Dec 23, 2008, at 8:57 PM, Darren Pilgrim wrote:
I'm enabling digest-md5 authentication with "[email protected]" 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?
Don't try to do anything special. Just: SELECT username as user, password FROM ..
