How do you do it if someone has nerfed the login? I have full access the mysql database and can MD5 harsh the new password.
Currently there is no recovery script, however this is planned. For now you will have to go into phpMyAdmin or MySQL and run the following
(First md5 your password)..
UPDATE users SET password='[new password]' WHERE uid='1';
Replacing [new password] with the MD5 of your new password, and if the user id of the password you are setting is not 1 then you will also have to change that.
Chris
With the latest phpMyAdmin's you can automatically MD5 your password at the same time while editing.
It should be in the dropdown box of options.
The problem isn't that the user has forgotten his password. He deleted the account.
I tried adding an account with userid 1 and username and password and in user group 1 but that didn't work for some reason.
The admin usergroup is 4. Group 1 is guests. :p
The users ID shouldn't matter, as long as they are in usergroup 4.
Ah that would explain my problem lol. Meh I just reinstalled. I have two more question though. Any plans to have it work with css external style sheets? and why does it use 3 charactor for yes no instead of booleans?
Quote:Any plans to have it work with css external style sheets?
This will be available in a later version..
Quote:and why does it use 3 charactor for yes no instead of booleans?
This should be changing when the code is being cleaned up too
I hate to resurrect this, but I'm in a small pickle. I host a small board at my work's intranet, and we recently went through a series of changes. I got a new PC, lots of backend infrastructure changed, etc. Bottom line: I went to log into MyBB and cannot. It's been eons since I actually entered that password, and after trying everything in the book, nothing was accepted. (This seems really odd to me.)
Every time I entered something it didn't like, it told me I had "-1" more attempts. I'm not sure I feel good about that either.
I did try having it email me my password information, but with the backend changes I referenced before, I'm not sure the server I'm hosting it on is even capable of doing so any longer. 20 minutes later, I've received no mail from it.
I Googled this, and since I do have access to the machine and can login to mysql, I gave this a shot. It claims to have taken the change just fine, as the row was updated (once I substituted "mybb_users" for the "users" quoted above), but the new password is not working either.
Thoughts? Thanks in advance!
- Ichi
PS - The board is so old it's still running 1.2.9. (I haven't had a chance to update it.)
In addition to setting the "password" to the md5'ed new password, you need to clear your user's "salt" field.
(2008-06-25, 09:09 PM)DennisTT Wrote: [ -> ]In addition to setting the "password" to the md5'ed new password, you need to clear your user's "salt" field.
Thanks for the FAST response DenisTT.
How do I do that? Sorry... I'm a little trigger shy with mysql - particularly since I now have this screwed up. I don't have the phpMyadmin stuff running, so I'm mysql command line one.
Thanks again!