use Rail console to reset gitlab root password

 1. Open a rails console: 

# gitlab-rails console

2. Find the user:

user = User.find_by_username 'root'

3. Reset the root password

newpass = 'secretpass'

user.password = newpass

user.password_confirmation = newpass

4. save the changes

user.save!

5. exit console

exit