MyBB Community Forums
[How To?] reset admin username - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [How To?] reset admin username (/thread-158548.html)



reset admin username - AliRezA Nasehi - 2014-09-03

i have really bad mistake. i change "administator" to "moderator" in admin panel and i cant enter to admin panel. please help me. Sad


RE: reset admin username - DevilKing - 2014-09-03

Go to: CPanel > Database Management > phpmyadmin > Click on "SQL" tab > and enter the following query and Press "Go"

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



RE: reset admin username - AliRezA Nasehi - 2014-09-03

thanks bro.
but its change my password.
username?
i change administator to moderator.
is it work?


RE: reset admin username - DevilKing - 2014-09-03

Yes you can change your username and password using your admin cp. If you further need help you can pm me with your forum url and demo admin account.


RE: reset admin username - AliRezA Nasehi - 2014-09-03

sent. please help.

i really thanks Euan T.
he solve my problem.

In the database, find your user in the mybb_users table and change the user group to "4".

Euan T Wrote:
AliRezA Nasehi Wrote:i have really bad mistake. i change "administator" to "moderator" in admin panel and i cant enter to admin panel. please help me. Sad

In the database, find your user in the mybb_users table and change the user group to "4".