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...e_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 Code:

<?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]

Originally Posted by 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

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]

Originally Posted by 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.

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