Resetting passwords

From Xinki Lab

Run this SQL query using phpmyadmin to reset a user's password to "password", replacing database prefix with that particular wiki's database prefix (if any) and the same with the user ID.

UPDATE database prefixuser SET user_password=MD5(CONCAT("user_id value-",MD5("password"))) WHERE user_id=user_id value

• Remember to tell the user to change their password to something much more secure immediately.