2018-07-25, 04:09 PM
Pages: 1 2
2018-07-25, 05:35 PM
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
[SQL Queries guidance]
admin panel PIN is stored in config.php file [in inc folder]
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]
2020-04-04, 09:25 AM
(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 selected2020-04-04, 09:44 AM
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
then you can execute above given SQL query
UPDATE mybb_users SET password = 'requiredNewPassword', salt = '' WHERE uid = '1';
2020-04-04, 10:16 AM
(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 tabhttps://gyazo.com/ebdff16bb49c4edd38a3422aed8793d4
then you can execute above given SQL query
UPDATE mybb_users SET password = 'requiredNewPassword', salt = '' WHERE uid = '1';
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 12020-04-04, 10:29 AM
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:40 AM
(2020-04-04, 10:29 AM).m. Wrote: [ -> ]hmm., change it like below & try it again
note : using back-tick mark (`) for table name, keywordsUPDATE `mybb_users` SET `password` = 'requiredNewPassword', salt = '' WHERE uid = '1';
single quote mark
is used for values on right side of =
I tried it says #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
2020-04-04, 11:01 AM
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
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:15 AM
(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
2020-04-04, 11:39 AM
"
would you like to PM me temporary access to your web host panel to check it
later you can change your login password
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