To reset the password for Admin user

[Tanvi]

Hello,

I was trying to explore the Manage Users link and by mistake I
clicked on "Suggest" option for password. Now I am not able to use my
old password. Can anybody please help me out in how to reset the
password as I tried with -- "Click here if you have forgotten your
password" link but its asking for email-id which I am unable to
recall.

Awaiting a positive response.

[njenney]

You may have to reset in the database. Do you have access to
phpMyAdmin? If so try to set a new password in the 'user' table. I am
not sure this will actually work. Just a thought.

[David Dwiggins]

I think if you set the password in the user table to blank in MySQL, it will let you log in without a password. Then you can use the change password function to reset it. 

Disclaimer: this is from memory -- have not tested it recently.

-David

--
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To post to this group, send email to resour...@googlegroups.com.
To unsubscribe from this group, send email to resourcespac...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/resourcespace?hl=en.

[Kasi Vps]

I tried, it didnt work initially, kept trying for almost a day, and thought of updating the steps, which might be useful.

Steps done 

1. Stopped the httpd and mysqld services

2.  mysqld_safe --skip-grant-tables &

3. mysql -u root

4. use rs2;

5. update user set password=PASSWORD("") where username='admin';       ### user keyword was modified in our setup as username, hence the change####

6.  flush privileges;

7. quit.

Kasi VPS
On Wednesday, November 28, 2012 2:46:06 AM UTC+5:30, Regis Zaleman wrote:

Just tried -  it worked.

[Paul Inkenbrandt]

This worked for me!  Thank you so much.

[Mehul Navsariwala]

[Allison Stec]

You'd have to change it manually in the mysql db's user table

Allison Stec
Asset Management Specialist
Colorhythm
http://www.colorhythm.com

Main Office: +1 415-399-9921
Fax: +1 415-399-9928

as...@colorhythm.com

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.org
---

You received this message because you are subscribed to the Google Groups "ResourceSpace" group.

To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[TimC]

Look at the user table in the resourcespace mysql db for the required user name and there you'll find the email address needed for the 'Forgotten password' link. It will send to that address when you type it. If it's not a valid email then update the record in the table to a new valid email and then enter that in the forgotten password link.