All users (including the admin) are stored in the database in the ost_staff table. Presuming that you have access to the database with another username/password that has (or can have) privs you should be able to run a MySQL query to change whats in there. It is stored as an MD5Hash iirc. Here is the query:

UPDATE `ost_staff` SET `passwd` = MD5( 'newpassword' ) WHERE `username` = 'username';

Obviously change newpassword to what you want the password to be, and username to the admin account name. This same query can be used for any user with those changes.

How to run a MySQL query varies depending on what OS your running under of course. :) I personally use a product called Navicat Lite at home. At work I have MySQL WorkBench installed. If you do not have a priv account in MySQL (like root) there are several good articles on the net about how to recover that password.

after upgrading from v.1.6 to v1.7 I can not login to SCP...

I tried UPDATE `ost_staff` SET `passwd` = MD5( ‘mynewpassword’ ) WHERE `username` = ‘myusername’ LIMIT 1 ; but still can't login

Any suggestions?

Thanks

after upgrading from v.1.6 to v1.7 I can not login to SCP...

I tried UPDATE `ost_staff` SET `passwd` = MD5( ‘mynewpassword’ ) WHERE `username` = ‘myusername’ LIMIT 1 ; but still can't login

Any suggestions?

Thanks

How is that possible? 1.7 doesn't even ship with an upgrader, yet! We specifically make it clear that it's not meant for production or upgrade of existing installations. :

Yes, I know... I am just testing this.

I have copied the v1.7 files over the v1.6 folder, except the ost-config.php

The password is good. I've decoded the passwd field from the DB with MD5 decoder.

Yes, I know... I am just testing this.

I have copied the v1.7 files over the v1.6 folder, except the ost-config.php

The password is good. I've decoded the passwd field from the DB with MD5 decoder.

Copying the files won't upgrade the database! V1.7 comes with new tables and database schema changes - which requires scripted upgrade to fully function.