Recover admin password

[RedBOX]

Anyway to do that or to reset it somehow?
The recover says ERROR: No such user

I guess it is because it searches the user's table but not the admin table.

[joximu]

lost password on login screen?

also see db ispcp, table admin about name and mail address of the admin (first entry?)

/J

[RedBOX]

The lost password screen says "no such user".

Can i replace the admin pass value in the mysql table with something else that you know i mean a known value of an encrypted string. I don't know if you understood me. I want to reset it with something like a default value.

[joximu]

you can set the password in the table
use the md5 function!

this should work.

/J

[RedBOX]

any keys for the func? Where is it?


//off-topic
I love the new ajax view of the forum...

Keep up the good work.

[joximu]

Log in to pma with user root (mysql root).
Select DB ispcp
Select table admin - look at the field content...

There should be the admin in the first cols... (normally id 1)

You can change the password - but use the md5 function to crypt it. (can be selected in pma left from the passwd-field...)

/J