Let’s say you forget your LimeSurvey admin password and, very importantly, the server it’s running on cannot send email. Since the normal method for resetting a forgotten password involves email you will need to update the password via the underlying MySQL database.The password is stored as a SHA256 hash, so you need to use the MySQL function SH2() to complete the update. The actual query looks like this:

UPDATE `tblpr_users`
SET PASSWORD = sha2('newPassword*',256)
WHERE uid = 1


Keep in mind that the table name (in this case tblpr_users) should be adjusted to whatever your table prefix is. Also, the password string (the first parameter in the SHA2 function) needs to be changed to whatever your password is.