Reset Admin Password ver1.02

[oklahomawebhost]

Hello, I'm running vers 1.02 Maui. I have a user who lost their admin password, and I've tried resetting it the method that is listed by searching the forums. (use phpmyadmin to either md5 a plain text password, or using a md5 generator and pasting in an already encrypted password). The password (key) does change in phpmyadmin, but no matter what I change it to, I'm not able to login.

There is also only 1 account on this site, which is the admin account.

My question is has anything changed, with the way the admin password is store in mysql in this version? Or is the password stored at a table besides cms_users?

Thanks,

OklahomaWebHost

[tsw]

UPDATE cms_users SET password=MD5('newpassword') WHERE user_id=1;

should do the trick...

[oklahomawebhost]

no dice?

[KoalaBlue]

Hi,

I don't quite understand the steps above on how to do this - can someone please detail step-by-step instructions, or point me to a page in the online documentation?

Thanks!

[tsw]

that is a sql command you run against your database.

open mysql client and select the right database, and check whats your table prefix (in this example it is cms_) and then run that command

UPDATE cms_users SET password=MD5('newpassword') WHERE user_id=1;

I think you can also do this from phpmyadmin, there is a place to run direct sql commands. or just use the edit command of phpmyadmin and set the password to be MD5('newpassword') didnt test this tho...

hope this helps

[KoalaBlue]

Hi TSW,

thanks for this - I can access MySQL through the admin panel of my hosting - I'll have a look there and see what I can do.

Just in case I do something wrong  is there something I should do to backup the database? I have never done this before

[pikkabbu]

GREAT !!

thank you so mucho 4 this.

Works fine.

pik

[oklahomawebhost]

I ended up having to re-install, but I think it turned out to be a database issue that was keeping the admin reset trick through phpmyadmin from working.

Anyways,

We're good

OklahomaWebHost