I set up mediawiki but unfortunately forgot the admin password and furthermore i hadn’t set up the admin password. So the quick thing to do was to try to try and reset the password via my phpmyadmin but I couldn’t do so. The user password field is in binary format. See the screenshot below :
Therefore I run this mysql statement to reset the password:
UPDATE [user] SET user_password = MD5(CONCAT(user_id, ‘-’, MD5(’newpassword‘))) WHERE user_id = uid
Where [user] = users table
uid = user id
Advertisement
