start > mediawiki password reset

mediawiki password reset

Created by alex. Last edited by alex, one year and 168 days ago. Viewed 2,883 times. #1

[edit] [rdf]

labels

attachments

Here's the SQL to reset the mediawiki password of a user:

use mediawikidb;
update user set user_password=md5(concat(user_id,'-',md5('newpassword'))) where user_name = "Alex";

The default admin username is WikiSysop, with user_id=1, so you could do:

update user set user_password=md5(concat('1-',md5('newadminpassword'))) where user_id=1;

Here's how you add a new user:

insert into user(user_name) values ("Alex");

then set a password as above. Keep in mind that usernames must start with a capital letter.

请以发表评论身份登录