How to reset user password for a MediaWiki instance using sqlite database?

0

The web server does not have email functionality, so the regular "forget password" feature does not work from the password resetting web page.

Also the standard documentation on resetting password does not explain how to do it for sqlite database.

How does one translate

MySQL salted (make sure both instances of "somesalt" are the same)

UPDATE `user` SET user_password = CONCAT(':B:somesalt:', MD5(CONCAT('somesalt-', MD5('somepass')))) WHERE user_name = 'someuser';

PostgreSQL unsalted

to suitable sqlite command?

qazwsx

Posted 2015-04-24T16:16:42.913

Reputation: 6 739

Answers

0

The docs do tell, when they say to use the command-line.

php maintenance/changePassword.php --user=example --password=newpassword

Do you also lack shell access?

Nemo

Posted 2015-04-24T16:16:42.913

Reputation: 1 050