ranchfor.blogg.se

md5() is available from MySQL version 3.23.2 and sha1() was added later in 4.0.2.

It returns a 16-byte string for MySQL versions prior to 4.1, and a 41-byte string (based on a double SHA-1 hash) for versions 4.1 and up. password() is the function used for MySQL's own user authentication system. In MySQL you can generate hashes internally using the password(), md5(), or sha1 functions.

select name from sysxlogins union all select _varbintohexstr(password)from sysxlogins Use function fn_varbintohexstr() to cast password in a hex string.Į.g.