How to reset admin password in Redmine

 How to reset admin password in Redmine

Firstly, we need to find the user ID of the admin account, I believe if this is the first account created, it will be 1 but best to make sure.

we can login to mysql as follows;

mysql -u root -p
 
mysql> use redmine;

mysql> select * from users;

Alternatively, if we have phpMyAdmin installed, check out the user ID from there.

We then proceed to the Redmine install directory. (this will differ depending on distribution etc).

Try /opt/remine/redmine-x.x.x

From within the install directory, start console as follows;

RAILS_ENV=production bundle exec rails c
 
Find the user using the ID from previous steps;

user = User.where(id: 1).first
 
Set a new password as follows;

user.password = 'password'
user.password_confirmation = 'password'
 
Save the changes;

user.save!

and finally, exit;

exit

source