Due no doubt to a mistake on my part, I know find that the user name and p/w I thought I'd specified for the wiki admin during setup weren't actually what went through. There is an account called "wikiadmin", so perhaps I somehow submitted the defaults.
In any case, could someone please explain, or direct me to instructions, to change the wiki admin account name and password? I have full access to both the server and the wiki DB. Surely someone has lost or forgotten their password before :-)
Let's hope this is the last installation goof on my part, Ken
Hi Ken,
this might be old info, but about 6 months ago this worked for me:
update user set user_password=md5(concat(user_id,'-',md5('newpassword'))) where user_name='wikiadmin';
After that you should be able to log in with the wikiadmin account and the new password.
Cheers, JP
Ken McDonald wrote:
Due no doubt to a mistake on my part, I know find that the user name and p/w I thought I'd specified for the wiki admin during setup weren't actually what went through. There is an account called "wikiadmin", so perhaps I somehow submitted the defaults.
In any case, could someone please explain, or direct me to instructions, to change the wiki admin account name and password? I have full access to both the server and the wiki DB. Surely someone has lost or forgotten their password before :-)
Let's hope this is the last installation goof on my part, Ken _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
On 5/24/06, Jan-Paul Köster Jan-Paul@jpkoester.de wrote:
this might be old info, but about 6 months ago this worked for me:
update user set user_password=md5(concat(user_id,'-',md5('newpassword'))) where user_name='wikiadmin';
I can confirm these instructions. They worked for me on 1.6.x recently, and the instructions are the same for 1.5.x.
You may need to tweak "user" if $wgDBprefix is set.
http://jrandomhacker.info/MediaWiki_tricks_and_tips#changing_a_password
On 24/05/06, Ken McDonald ken@pixologic.com wrote:
Due no doubt to a mistake on my part, I know find that the user name and p/w I thought I'd specified for the wiki admin during setup weren't actually what went through. There is an account called "wikiadmin", so perhaps I somehow submitted the defaults.
In any case, could someone please explain, or direct me to instructions, to change the wiki admin account name and password? I have full access to both the server and the wiki DB. Surely someone has lost or forgotten their password before :-)
http://www.google.co.uk/search?q=MediaWiki+password+MD5 throws up some nice results.
Rob Church
mediawiki-l@lists.wikimedia.org