retrieve password?

[Paulhuang]

Hi,

Is there anyway that I can retrieve my password to go to editors if I have forgotten the password? Thanks in advance.

Paul

[Ewan]

I guess you'd have to speak to your hosting company as the username/password are for a folder hosted on their servers.

[Pekka]

Paul, do you have PHPmyAdmin installed on your server? If you have one, I can give you instructions how to reset the pass - else let me know and I'll code you as small pass reset script.

[Paulhuang]

Hi Pekka,

Yes, I believe I have PhPadmin installed on the server. Thanks for the help.

Regards,
Paul

[Pekka]

Hi Pekka,

Yes, I believe I have PhPadmin installed on the server. Thanks for the help.

Regards,
Paul

Ok, this is quite simple, open PhpMyAdmin and:

1. select your database (often you have it preselected if there is only one).
2. open "SQL" tab. This section of PhpMyAdmin lets you run queries on database.
3. paste this code into SQL tab's text area, replacing what may be there:

UPDATE ee_admin SET ee_admin_pass = MD5( 'pass' ) WHERE ee_admin_id = '1' LIMIT 1

4. and press "Go" button.

On top of that page you should now see in bold text...

Affected rows: 1

...and this means the pass has been reset to "pass". Above instructions are for PhpMyAdmin 2.5.5 but it should work about same in all versions. If you have some other admin tool for SQL there is always a page where you can give SQL commands.

[Paulhuang]

Hi Pekka,

Wonderful. Thanks again for help. By the way, how do I pay for EE?

Paul