MyBB Community Forums

Full Version: Changing usernames and password through sql command
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Can someone tell me how do I change some usernames and password through sql command?

Because I dont know why but I cant log in on my board, ;/ I don't know what is going on. I tried to reset my password from my board, I got the email for the password reset but still cant log in... please help
Run this, it will change your password to test

UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = '1';

Change the 1 to your UID if it isn't 1.

Also you would have found an answer much quicker to this if you'd searched for it before making a thread Smile