Here are the steps to change the password of a user in the database:
1. If your VPS or computer has Linux OS, open the terminal and type "php -a" to run PHP interactively.
$ php -a
Interactive mode enabled
2. Once the interactive mode is enabled. Type "echo password_hash('my_new_pass', 1);", where my_new_pass is your new password.
php > echo password_hash('my_new_pass', 1);
3. Copy the hash value of your password generated above and access your Q2A database from PHPMYADMIN or terminal.
4. Run the following SQL:
SET passhash = 'hash_value_of_password'
WHERE userid = YOUR_USER_ID;
Where hash_value_of_password is the value from step 2. Now you should be able to log in using the new password.