Ok. I have been trying to figure out the way the values are stored in the db for user passwords. (No, not trying to view them. Trying to match them so someone can login to their ns account to create a profile type setup).
So far, I have got it figured out to use the decode(`pass`,"MysqlSecure") ... However, when just messing with the sql of it, encode("my personal pass","MysqlSecure") doesnt = what should be in `pass`. I come a whole lot closer using encode(md5("my personal pass"),"MysqlSecure") (Im assuming because Im using enc_md5 in my encryption method). I can atleast get the right length... however, it obviously isnt right still.
Its a 32 length str, so md5 has to be involved somehow...
Yes, I am using a key, no it isnt MysqlSecure...
No, my pass isnt "my personal pass"... those were used as placeholders to hopefully help show what Im trying to achieve.
Please dont ask tiny questions such as "Are you sure your using MysqlSecure with a key, not as md5" or whatever. Not trying to insult someones intelligence here. Just please dont insult mine.
Basically, all Im asking is what is the method to come up to the string that gets encoded with the key?
Examples would be amazing.
EDIT: And because I forgot to say it, Im using 1.8.7. (I saw the last thread which was SOMEWHAT relevant to my interests... Just the reverse. =P)
With that being said, be nice... Im atleast on a current version.