For better security, the password is always stored as a hash -- but you can generate that hash easily in MySQL. For example, to change a username and password:
- Code: Select all
UPDATE users SET username='new_username_here', password=MD5(CONCAT('new_username_here', 'new_password_here')) WHERE username='old_username_here';
In this example I'm using MD5 hashing, which is the default -- if you're using SHA1 (check config.inc.php), you can simply use the "SHA1" function instead of "MD5".
The hashed password is an MD5 or SHA1 hash of the concatenation of the username and password.
Public Knowledge Project Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada