Changing mediawiki user name

From Foochal

Login to the mediawiki database

 mysql mediawiki -h localhost -u mediawiki -p

You can change your nickname from the preferences. However, you cannot change your name. Suppose your old name is 'OldName'.

update user set user_name = 'NewName' where user_name = 'OldName';
update revision set rev_user_text = 'NewName' where rev_user_text = 'OldName';
update recentchanges set rc_user_text = 'NewName' where rc_user_text = 'OldName';