Search the Community
Showing results for tags 'mysql php encryption'.
Found 1 result
-
Hi guys, I have a users table that holds the password as a varchar(200) in a utf8_unicode_ci collation. It uses the multiple passes of the hashmac function to encrypt it as follows : hash_hmac('sha512', $pass, $salt, true) . I know I should set the password as a set character length but couldn't work out what the length should be and i think this must be part of the issue. All works fine and dandy, i can verify the users the lot, the problem is when I create a back up and re-instate it, the passwords don't seem to save properly. Currently I back up using the phpMyAdmin as an SQL file and then copy and paste that file data into SQL query window of phpMyAdmin. I've also noticed that if I try and change the record (any field) using the phpMyAdmin interface (apart from the SQL query window) it also corrupts the password. I'm therefore assuming that I need to change the storage type for the password to keep its integrity but to what to and what size or is there something else that I'm missing? cheers Zen
