bgbs Posted February 5, 2010 Share Posted February 5, 2010 I'm not a mysql phpmyadmin guru, but I frequently use phpmyadmin to tinkle with the database to make various changes. I run a membership type website in which people open accounts and utilize services. The problem I have is that if I change a password for any registered member using phpmyadmin then the password no longer works; a member cannot login with it. The password field type is set as varchar(64) and function is not set. I tried applying different functions from such as ASCI, password, CHAR,HEX, but nothing I do works. Does anyone know what I'm supposed to do now? Quote Link to comment Share on other sites More sharing options...
fizix Posted February 5, 2010 Share Posted February 5, 2010 Does the password look like a string of numbers and letters before you change it? If so it could be an MD5 hash (or other hash). If that's the case you'd need to first encode the password to MD5 with a website like this one: http://7thspace.com/webmaster_tools/online_md5_encoder.html Quote Link to comment Share on other sites More sharing options...
mapleleaf Posted February 5, 2010 Share Posted February 5, 2010 or sha1 and there may be a salt field too Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.