Thread:Project:Support desk/Can't Change Password Via phpMyAdmin!

Hello,

I forgot my MediaWiki password, so I tried to reset the password by letting it send a reset mail to me. But it doesn't send a mail. And since my host doesn't give me SSH or any kind of console access, I had to try to reset the password via the database directly. For that, I used this:

UPDATE user SET user_password = MD5( CONCAT( user_id, '-', MD5( 'NEWPASS' ) ) ) WHERE user_id =1

When I executed it, it said "1 row affected", so I thought it would be working, but it didn't. I still couldn't login. Why doesn't it work when I reset the password like this? Can anybody help me, as I have no way of resetting my password now :(

Info: - MediaWiki Version: 1.21.2 - PHP Version: 5.3.27 (cgi-fcgi) - MySQL Version: 5.5.33-log

And I also have an extra note: Whenever I try to login, it just reloads the page and it says no message. The exact same happens when I reset my password with the email option, it just reloads. I've tried private browsing and clearing all my cookies, still doesn't work. I don't know if it is normal for it not to show a message like "Failed to login".