Manually changing GOD password via phpmyadmin

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I needed to change the password for the God account so I went into phpmyadmin and was going to do it manually. Input the new password and selected MD5. Clicked on Go and got this result.

Affected rows: 0

It seems I can no longer manually change this when in PHP4 I could.

The SQL query looked like this.

Code:

UPDATE `xxxxxxx_main`.`nuke_authors` SET `pwd` = MD5( 'xxxxxxxx' ) WHERE CONVERT( `nuke_authors`.`aid` USING utf8 ) = 'xxxxxx' LIMIT 1 ;

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

New admin for modules cannot login though admin.php

Before the guy said it was telling him Begone.

Now all that happens is the login page refreshes.

The user is a normal module admin and not a superuser.

fkelly · Posted: Wed Dec 12, 2007 7:45 pm

just go in and edit the field in phpmyadmin. under function choose md5 and then type in the text that you want to apply the md5 to. to edit the field, browse the file, then pick the record you want to edit. There is no need to write a query for this, phpMyAdmin will do it for you.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

fkelly wrote:

just go in and edit the field in phpmyadmin. under function choose md5 and then type in the text that you want to apply the md5 to. to edit the field, browse the file, then pick the record you want to edit. There is no need to write a query for this, phpMyAdmin will do it for you.

Donovan wrote:

I went into phpmyadmin and was going to do it manually. Input the new password and selected MD5. Clicked on Go and got this result.

I did just what I wrote. I used phpmyadmin and got ...

Affected rows: 0

montego · Posted: Thu Dec 13, 2007 7:18 am

I don't understand why it is putting in the CONVERT. There is something odd going on with regards to charsets (but I have no idea what). Try this instead:

UPDATE `xxxxxxx_main`.`nuke_authors` SET `pwd` = MD5( 'xxxxxxxx' ) WHERE `aid` = 'xxxxxx' LIMIT 1 ;

You may have to do this manually (the SQL that is).

Gremmie · Posted: Thu Dec 13, 2007 8:13 am

Can't you just delete the GOD record and the next time you visit admin.php it will prompt you to create a new one? Don't try this until someone confirms that will happen. Wink