MyBB Community Forums
Reset ACP password and PIN - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Security Management and Support (https://community.mybb.com/forum-179.html)
+--- Thread: Reset ACP password and PIN (/thread-218895.html)

Pages: 1 2


Reset ACP password and PIN - jtapp - 2018-07-25

I am unable to log in to the ACP. How do I go about changing the ACP login credentials - email,password and pin - from the backend?


RE: Reset ACP password and PIN - .m. - 2018-07-25

users' credentials are stored in the database.
you can change them in users table of the database.

SQL query can be like below for changing password of user with user id as 1
UPDATE mybb_users SET password = 'requiredPassword', salt = '' WHERE uid = '1';

[SQL Queries guidance]

admin panel PIN is stored in config.php file [in inc folder]


RE: Reset ACP password and PIN - yontox - 2020-04-04

(2018-07-25, 05:35 PM).m. Wrote: users' credentials are stored in the database.
you can change them in users table of the database.

SQL query can be like below for changing password of user with user id as 1
UPDATE mybb_users SET password = 'requiredPassword', salt = '' WHERE uid = '1';

[SQL Queries guidance]

admin panel PIN is stored in config.php file [in inc folder]

I'm getting this error while restoring my password
https://gyazo.com/c62b5a321fa9015621ae63bb88e554c0

I tried
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X'
and it says no database selected


RE: Reset ACP password and PIN - .m. - 2020-04-04

on the left column, click on database name (chil4065_bb) and then on right side click on SQL tab
then you can execute above given SQL query
UPDATE mybb_users SET password = 'requiredNewPassword', salt = '' WHERE uid = '1';



RE: Reset ACP password and PIN - yontox - 2020-04-04

(2020-04-04, 09:44 AM).m. Wrote: on the left column, click on database name (chil4065_bb) and then on right side click on SQL tab
then you can execute above given SQL query
UPDATE mybb_users SET password = 'requiredNewPassword', salt = '' WHERE uid = '1';
https://gyazo.com/ebdff16bb49c4edd38a3422aed8793d4

same error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mybb_users WHERE uid = '1'' at line 1


RE: Reset ACP password and PIN - .m. - 2020-04-04

hmm., change it like below & try it again
UPDATE `mybb_users` SET `password` = 'requiredNewPassword', salt = '' WHERE uid = '1';
note : using back-tick mark (`) for table name, keywords
single quote mark is used for values on right side of =


RE: Reset ACP password and PIN - yontox - 2020-04-04

(2020-04-04, 10:29 AM).m. Wrote: hmm., change it like below & try it again
UPDATE `mybb_users` SET `password` = 'requiredNewPassword', salt = '' WHERE uid = '1';
note : using back-tick mark (`) for table name, keywords
single quote mark is used for values on right side of =

I tried it says [Image: dot.gif] #1046 - No database selected
Should I make a database called mybb-users?

Also, I'm not sure what you mean by
note : using back-tick mark (`) for table name, keywords

single quote mark is used for values on right side of =

I'm quite nooby


RE: Reset ACP password and PIN - .m. - 2020-04-04

for "No database selected" , see above post #4

copy & paste below code as is for SQL query
only change 'requiredNewPassword' after pasting into SQL box

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



RE: Reset ACP password and PIN - yontox - 2020-04-04

(2020-04-04, 11:01 AM).m. Wrote: for "No database selected" , see above post #4

copy & paste below code as is for SQL query
only change 'requiredNewPassword' after pasting into SQL box

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

Still getting no database selected

I copy pasted it in the SQL query box and changed requirednewpassword

Should I make a database called mybb-users? There is none


RE: Reset ACP password and PIN - .m. - 2020-04-04

"mybb_users" is a table of your forum's database.

would you like to PM me temporary access to your web host panel to check it
later you can change your login password