Resetting Mediawiki Admin Password

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

CMS Made Simple Da Bomb!!

I had a website project and had a tight time schedule , I first deployed the website using typo3 but oops I got stuck on the way.  Typo3 requires alot of learning and support is quiet scarce.

I run into CMS Made Simple via google and walaaah!! It had the features I required and on trying it out….I was able to deploy my website project within six hours. The documentation and online support is awosome. If  CMS Made Simple was a girl, I could have married her…lol.

Props to CMS Made Simple developers.