Lost admin password

I was testing out the forgot password feature using the admin account email address. My mail server failed to receive the email. So now my password has been reset and I have no idea how to get in.

I have full access to the database via mysql and I have full access to the server itself via SSH.

Any ideas?

http://www.boonex.com/forums/topic/Reset-Admin-Password.htm

 I tried running that but it doesn't seem to work for me. My admin ID is 679 (I migrated from 6.1.6 and that's the ID it was assigned). I modified the statement accordingly and it doesn't seem to work.

I do notice it says to run it in myphpadmin, I'm using MySQL Query browser. I don't have myphpadmin installed here.

Could that be the issue? Maybe the statement for mysql query browser is different?

i think i still have the upgrade on my server if you want me to get the user and password for you....

I sent you the password and salt  after you change that make sure to empty the cache folder

I was not able to get in. Any ideas on resetting the password?

That procedure above is how dolphin sets passwords.

Repeat the 2 queries and then clear the entire cache by deleteing the contents of the cache folder.

If that fails, setup a new account then find it in the database and set the role field to 3 which will make that account admin.

Then log in with that account and set the password for the old account.

That procedure above should work though. It's the exact same way dolphin uses when a password is changed. As long as the ID number in both queries is accurate then it should work.

Try to check under the admin panel you maybe find the password there

lol

said your mail server failed to receive the email

then go to phpmyadmin and change the email ..

phpmyadmin > select your data base

and just run this query

UPDATE profiles SET Email="PUT YOUR EMAIL HERE" WHERE ID=679

if you got an error please post it in here cuz i think that you have the magic quotes:on . and you dont have a phpmyadmin so i think thats a problem . just keep us updated

but if you mean the server your hosting on failed to send the email then it's anouther case ...

 and if the referenced query fails when trying to update the email address that is because the table name is misstated

profiles --> Profiles

yes the table name is case sensitive

UPDATE profiles SET Email="PUT YOUR EMAIL HERE" WHERE ID=679

 but then as further mentioned, if the server is not sending the email, then you have not configured sendmail() or some other method of a mail server.

sorry missed that must've been from hurry

The mail is being sent fine. My network configuration was preventing me from receiving it. All is well now. I took an old db backup and restored it to a new db. Then I just swapped hashes and salts between databases.

hello i need some help please  i forgot my email and so the password of my addmin  of my dolphing to get to my  admin  acound on my website    i know my id name but i dont remeber my pasword and email eather but yes  i have accest to my c panel   i know this might sound silly but i need some help how i can get in to my admin account pleaseee??

http://www.boonex.com/forums/topic/Reset-Admin-Password.htm

Source: http://www.boonex.com/forums/topic/Lost-admin-password.htm

hi  Nathan   thank u soo much for respond   ... am i in the right place ? on the image is in there where i can make those changes ?? or what do i need to do there or im doing it wrong  ? than u one more time in advance  sorry im kind  new on these c panel stuff  

Go to the SQL tab at the top of the page and run the two SQL queries mentioned in that topic.  Be sure to follow all directions.