Per Farmsoft Studios and SoftHints, one can follow the steps below:

1. Generate Bcrypt hash from PasswordHashing
2. Get the ghost config password (database access)

cd /var/www/ghost
ghost config get database.connection.password

2. Login to mysql and execute the code below (replacing with hash and respective user's e-mail)

mysql -u [ghost] -p
use my_ghost_base;
select * from users;
UPDATE users SET password='[PASTE_HASH_HERE]' WHERE email = '[YOUR_EMAIL_ADDRESS]';
exit

3. Login to Ghost with the new password

4. Reset your user's password