MyBB Community Forums

Full Version: Reset ACP password and PIN
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
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?
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]
(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
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';
(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
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 =
(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
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';
(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
"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
Pages: 1 2