GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com
MTNCOMP | List | Table

myBlog

myBlog Home

Blog


SQL

SQL hash md5 function review

by Mountain Computers Inc., Publication Date: Monday, January 14, 2019
View Count: 494, Keywords: sql, md5 hash, wordpress, Hashtags: #sql #md5hash #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 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.

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