(2011-05-28, 11:07 AM)Stenka Wrote: [ -> ]Yeah, by deleting them first works, but when i add my mysql database, then my forum requires new installation..
No, you need to change the database settings in /inc/config.php and your cookie settings in /inc/settings.php.
(2011-05-28, 10:52 AM)Aries-Belgium Wrote: [ -> ] (2011-05-28, 10:47 AM)Anatoxin Wrote: [ -> ]I have similar problem, but I forgot my DB pass. How can I change in forum the old pass for the new, without new installation?
Try to run this in phpMyAdmin:
UPDATE mybb_users SET password = 'tmppassword121564846', salt = '' WHERE uid = '1';
You might need to change the table prefix (mybb_) and the uid (1) to make it work for your situation.
Now login with this password: tmppassword121564846
And change your password again via UserCP.
This won't work as the database only stores hashed values. Run this instead:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = '1'
Will reset your password to "test".
(2011-05-28, 11:43 AM)pyridine Wrote: [ -> ] (2011-05-28, 10:52 AM)Aries-Belgium Wrote: [ -> ] (2011-05-28, 10:47 AM)Anatoxin Wrote: [ -> ]I have similar problem, but I forgot my DB pass. How can I change in forum the old pass for the new, without new installation?
Try to run this in phpMyAdmin:
UPDATE mybb_users SET password = 'tmppassword121564846', salt = '' WHERE uid = '1';
You might need to change the table prefix (mybb_) and the uid (1) to make it work for your situation.
Now login with this password: tmppassword121564846
And change your password again via UserCP.
This won't work as the database only stores hashed values. Run this instead:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = '1'
Will reset your password to "test".
Oeps, sorry. Forgot to add the MD5 function.