I changed password of database. but I forgot to change it from admin cp, now I can't able to see my form, It gives me error, access denied for user ****** using password. How to change password internally I mean from database ?
open .inc/config.php file in a code editor (eg. notepad++) AND change database password in it ...
Run this query:
This will reset the password to test
UPDATE `mybb_users` SET `salt` = '', `password` = '098f6bcd4621d373cade4e832627b4f6' WHERE `uid` = '1';
Replace uid with the uid of the user you want to change the password of
EDIT: you might have to change the mybb_ with your table prefix if you're using a different table prefix.