Jump to the post that solved this thread.
Solved: 6 Years, 4 Months ago [General] Lost password
#1
Solved: 6 Years, 4 Months ago
Hey all,

I lost my password. I'm unable to login due to the fact I closed my forum, and I've attempting to re-open my forum (nothing changes) and reset the password from phpmyadmin with no luck.

All the changes I make in the database don't seem to be doing anything to my forum. When I revoke privilages it brings up a SQL error. So I cannot figure whats going wrong. I just want to access my board again!

http://politicshub.co.uk/index.php

Thank you,
Matt
MixedMatts Blog - My blog!
Reply
#2
Solved: 6 Years, 4 Months ago
Are you sure you reset the password for the correct user? What's your uid and the query you run?
Reply
#3
Solved: 6 Years, 4 Months ago
Yes, uid is "1" and I didn't use a query I went into the database and change the password value using a MD5 hash. I changed it to numbers too and nothing works.

Thanks,
MixedMatts Blog - My blog!
Reply
#4
Solved: 6 Years, 4 Months ago
Well, did you reset the salt column that way too?
Reply
#5
Solved: 6 Years, 4 Months ago
UPDATE `mybb_users` SET `salt` = '', `password` = MD5('your new password here') WHERE `uid` = '1';
No longer involved in the MyBB project.
Reply
#6
Solved: 6 Years, 4 Months ago
(2014-12-07, 04:29 AM)Nathan Malcolm Wrote:
UPDATE `mybb_users` SET `salt` = '', `password` = MD5('your new password here') WHERE `uid` = '1';

If no have salt - yes Smile

Can generate md5 here http://www.md5.cz/

example:

Password: lol123
md5: 8f036369a5cd26454949e594fb9e0a2d

Example2:

<?php
$haslo = 'test';
$salt = 'ziarno_321';
$hashed = md5($haslo.$salt);
?>

„test” salt = 15d48611a95ecf9d0f14558368200e36
„test” no have salt = 098f6bcd4621d373cade4e832627b4f6

Repeat:
UPDATE `mybb_users` SET `salt` = '', `password` = MD5('your new password here') WHERE `uid` = 'you user id here'; 

uid can look here (default is 1):
   
Reply
#7
Solved: 6 Years, 4 Months ago
I have salt and have entered it into that query given by Nathan. No luck and can not login.... I have been MD5 hashing too. It still won't work just throws errors.
MixedMatts Blog - My blog!
Reply
#8
Solved: 6 Years, 4 Months ago
Forget about the salt. Run the query I gave you -- just change the password.
No longer involved in the MyBB project.
Reply
#9
Solved: 6 Years, 4 Months ago
(2014-12-07, 01:00 PM)matt4 Wrote: I have salt and have entered it into that query given by Nathan

That's the problem, as I said above you should reset it (set to empty).
Reply
#10
Solved: 6 Years, 4 Months ago
I tried both blank and empty and it still won't let me in. I'm baffled. I've tried clearing my browser cache.
Any other ideas what this could be?

Thank you,
MixedMatts Blog - My blog!
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)