Kiyor | Created: 06-07-16 03:07:13, Last Update: 06-07-16 03:07:31
sudo -u opscode-pgsql /opt/opscode/embedded/bin/psql opscode_chef
select username,hashed_password,salt,email from users;
#copy your known username's password and salt
update users set hashed_password = 'xxx',salt = 'xxx' where username = 'xxx';