EE Admin Password Problem

[jaypie77]

So I thought I had successfully changed my password. I logged out and now I'm stuck out. I did a search on resetting the password, but I couldn't understand the one thread that seemed to address this, so I'm going to ask:

What is the best way to reset your password in EE? (Speak slowly, I am a newbie.)

[Pekka]

I sent you a PM, but this may be useful for others, too:

Save the following code in your input folder as file SCRIPT_reset_username_and_pass.php

Then browse to http://www.yoursite.com/your_gallery/your_input/SCRIPT_reset_username_and_pass.php (edit address to suit your site)

That will set

user: admin
pass: pass

REMEMBER to set a new username pass after that in misc settings. Or edit them to file below and run it again.



<?php
include ("toroot.php");
include ($toroot . "add/connect.php");



$username = "admin";
$pass = md5("pass");



$clear = mysql_query("
DELETE FROM ee_admin
");
$do_an_owner = mysql_query("
INSERT
ee_admin
SET
ee_admin_id = '1',
ee_admin_name = '{$username}',
ee_admin_pass = '{$pass}'
");

?>


Let me know if this helped you! :)

[jaypie77]

Awesome, that did the trick. I will certainly save a copy of this code somewhere (not in the input directory, of course). Thanks for the help.

[drparker]

Thanks. It just saved me!

[seanspeng]

I was trying this on a 1.5 EE, just moved from one server to another server, I ran this script for a couple of times, and the login of admin and pass did not work. I tried with IE and firefox. Any other way I can reset the admin password?

Thanks!

[Pekka]

Unzip SCRIPT_reset_username_and_pass.zip in your admin folder and run it. Then delete the php file.

[seanspeng]

I used the code that you posted above. I did not see there is a zip file of SCRIPT_reset_username_and_pass.zip in the admin folder. I am on 1.5 version.

[Pekka]

ok, that explains it. Sorry for misinfo.

[seanspeng]

Ok, so what should I do next to reset the password?

[DavidW]

Are you sure that the database connection details are correctly configured in EE? If so, I can't see why the chunk of PHP that Pekka posted above isn't working.

Do you have an installation of phpMyAdmin that you can use to manipulate the EE database? If so, that would provide another alternative - select the database, select the ee_admin table, press Browse and change ee_admin_pass to 1a1dc91c907325c69271ddf0c944bc72 (which is pass in the appropriate format).



David

[seanspeng]

Are you sure that the database connection details are correctly configured in EE? If so, I can't see why the chunk of PHP that Pekka posted above isn't working.

Do you have an installation of phpMyAdmin that you can use to manipulate the EE database? If so, that would provide another alternative - select the database, select the ee_admin table, press Browse and change ee_admin_pass to 1a1dc91c907325c69271ddf0c944bc72 (which is pass in the appropriate format).
David

I just checked the admin password via phpMyAdmin, and the password is already:
1a1dc91c907325c69271ddf0c944bc72

So that means the password reset script has already made the change. But I cannot login. The admin name is "admin".

When I put admin and pass, the screen flash for a second or so, and I am back to login page again... very wired.

[wkitty42]

have you flushed your browser cache?

what about removing the EE cookie?

[seanspeng]

I have three web sites with EE installed. But they worked fine before. I even tried with a different computer, and it does not work with this particular one now. I have tried to clear the EE cookies, it did not help. I cleared the cache, also no help.

I have used EE for a long time, and this is the first time it happened to me.

[seanspeng]

Pekka,

I know you are a busy man... But we really need your help. We are completely stuck here. Gallery has been off for days.

Thanks in advance for your help.

[Pekka]

Pekka,

I know you are a busy man... But we really need your help. We are completely stuck here. Gallery has been off for days.

Thanks in advance for your help.

PM me access details and I'll see what the problem is. PHPmyadmin access would be a plus.

[Pekka]

Please also note the time difference - it's 3am here now so support will be closed for few hours soon :)

[seanspeng]

The problem was solved by upgrading to v2.01. Thanks Pekka.

[MichaelChristopher]

I'm now having the same problem as seanspeng. I've used the reset password script, checked the phpMyAdmin that the admin table has the right username and password entry, but when I enter the username and password in the login screen I get a flash and then right back to the login screen. (Can't upgrade to v2 for awhile -- swamped with work, and many customizations.) HELP!

[UweB]

Did you try a different broswer?

If it works there perhaps it helps if you delete the cookies which come from your ee sites web server... also there was something not working with the cookies name. If i remember this correctly, in my case the _ was converted by the webserver so i had a wrong cookie name in my browser.

[MichaelChristopher]

Same problem in IE and Firefox. Have deleted all cookies, same issue. There is simply no way at all now to use my EE.

[photocroatia]

I have the same problem as this is there a solution, ive checked and my password is still 1a1dc91c907325c69271ddf0c944bc72, somebody please help