myBlog myBlog Home

Back to Blog MTNCOMP


SQL hash md5 function review

Published: Monday, January 14, 2019 written by Drew Jackson
View Count: 56
Keywords: sql, md5 hash, wordpress



So back in 2011, 2014, 2017, had to do some md5 hash function review for passwords. Its always fun to have to forward and reverse a password for MD5 match up for word press. Not!!
 
more to come...
 
UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername'

'openSQL on mariadb
select MD5('Microsoft')
select MD5('klw2mm2')


'microsoft sql on sqlserver
SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'Microsoft')), 3, 32)
SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'klw2mm2')), 3, 32)
SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'klw2mm249')), 3, 32)
SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', '$BiggestLittleCity149')), 3, 32)

 


if you found this article helpful, consider contributing $10, 20 or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2019 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.