SQL hash md5 function review Mountain Computers MTNCOMP GGPCTU 775-287-9552

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!!

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 an Andrew Jackson 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.

SQL hash md5 function review

by Mountain Computers Inc., Publication Date: Monday, January 14, 2019

View Count: 1588, Keywords: sql, md5 hash, wordpress, Hashtags: #sql #md5hash #wordpress

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson 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.