Admin password reset

Submitted by manoj on 2011-08-09


How can I reset the password for the administrator account? There seems to be no apparent way to do it. Please help.


With version 0.8.5 of the server it's quite easy - just change the value of the user_passwd column in the users table to the MD5 hash of the password, e.g.

UPDATE users SET user_passwd = MD5('yournewpassword') WHERE user_login = 'admin'

In case of version 1.0, the password is hashed using a more complex algorithm to make it more secure. You can use the online password hasher to calculate the password hash. It was designed for Wordpress and Drupal but it is also compatible with WebIssues.