Admin Password - i've lost it

[computer]

HELP,,,,,,

I've just created my admin account, wrote it down and lost the paper!!!! The password was quite complex... is there any way to get it back!!!!

[chatserv]

Using phpMyAdmin go to the nuke_authors table and make your pass dc647eb65e6711e155375218212b3964
that will make it Password, then just login and change it.

[namsul]

I just created a FAQ for nuke to post this damn handy fix. I'm sure thats not the last time this question will be posted.

[amp2000]

Thanks for the tip chatserv, kinda dangerous to be giving out that info on a public forum though, MODS please delete this before it gets in the wrong hands!

No flames intened chatserv:)

[chatserv]

Why is it dangerous? i'm just telling you how to change your lost admin pass so that you can get a new one, before nuke 5.5 Password used to be the default God account password on all first installs.

[amp2000]

As I said before, no flames intended;)

I personally think it's dangerous cos if someone has the DB pass they can now have admin access. (before u say it, I know only the admin should have the DB pass)

P.S. I only want the thread deleted cos I've read it, saved it and dont want anyone else to know, LOL

Peace
amp2000

[Humpa]

oh ... I see what you are saying, amp2000.

I was all set to post and say how there is no security risk to posting this (common-knowledge) information.

You are just saying that since other's have access to your phpMyAdmin, then they can now change other people's password (yours), and have admin access, because they have this secret(?) code.

If they have access to your DB, then they already have admin access.

[amp2000]

I knew replying to this would hit me back.....

chatserv, humpa, you guys know your stuff back to front, I know that, I wasnt intending to criticise or flame anyone, I was just writing what I was thinking at the time.

Cheer's
amp2000

[chatserv]

I think what really matters is you were able to solve the problem (i hope), if that was the case then we managed to get something acomplished and that's the whole idea, good luck on the site, glad i could help.

[computer]

Thanks guys

[hicho]

hello,
i am new here and i have the same problem ... but i dont know where in nuke_authors to put this long pass and what about the username ... guys its been a week and still i am not able to login to my admin area .

[chatserv]

Using phpMyAdmin you should go to the authors table and look for your admin username in it, it should be listed there, click on edit and change the password it has now for the one i mention above, when done login to the site and change the pass through the edit admins option in nuke's admin section.

[hicho]

table nuke_authors running on ... am there

there is a table :
field type
name varchar(20) No Change Drop Primary Index Unique Fulltext

here ??

[chatserv]

There should be a browse button in that window, the window where you're at only shows the structure of the table not its content.

[hicho]

i think i've found it there is fields in it
to fill e-mail pass aid name ... shell i put the long pass or one from me

[chatserv]

If you found your admin username in there click edit and enter the long password in the proper field, should be the one named pwd

[hicho]

ok what shell i put in "aid"
i did put my user name in "name" ?

[chatserv]

You were supposed to only change the value for pwd, nothing else.

[hicho]

am sorry man it seems i didnt get u well
am i able to del and re-make a new one ...

[chatserv]

If you are using nuke 6.0 and you are the only site's admin, delete that admin entry and then try going to your site's admin section, it should tell you there are no superuser accounts, then you'll be able to recreate it. I am not sure what doing this will cause if you have a lot of content on your site so you should at least try using the same username you had before to create the new one.