How to Reset Password in Redmine

1. Login MySQL and find the user id

mysql -u root -p             # login MySQL
 
mysql> use redmine;          # choose redmine database
mysql> select * from users;  # show all users' information

2. Go to the redmine folder and change the password

# start console
RAILS_ENV=production bundle exec rails c
 
# find your user
user = User.where(id: 1).first
 
# set new password
user.password = 'password'
user.password_confirmation = 'password'
 
# save changes
user.save!

3. Login redmine and change the password

Now, you can login your account with password password, and then you can change your password in My Account page.

Reference

• https://stackoverflow.com/a/30666786/2802074