How to reset admin password in gitlab

foo.rb

# logon at your gitlab server
#
# $ sudo gitlab-rails console production


Loading production environment (Rails 4.2.7.1)
irb(main):001:0> user = User.where(id: 1).first
=> #< USER ADMIN >
irb(main):002:0> user.password = 'my_new_pass'
irb(main):003:0> user.password_confirmation = 'my_new_pass'
=> "my_new_pass"
irb(main):004:0> user.save!
Enqueued ActionMailer::DeliveryJob (Job ID: a-fancy-alphanumerical-id ) to Sidekiq(mailers) with arguments: "DeviseMailer", "password_change", "deliver_now", gid://gitlab/User/1
=> true