How to reset Login and Password through CPanel

First, hats off to a Guest user in the forum for the SQL patch to reset the login and password. However, my access is through CPanel and the steps had to be modified a bit.

To reset Login and Password for Advanced GuestBook on MySQL server, accessed through CPanel:

1. Log in to CPanel
2. Go to Advanced Options
3. Select MySQL Databases
4. Scroll down to bottom and click on phpMyAdmin
5. Select correct database (usually somename_agbook1)
6. On right side of screen select SQL
7. In Data Entry field delete "SELECT * FROM `book_auth` WHERE 1"
8. In Data Entry Field, paste the following two lines:

delete from book_auth;
INSERT INTO book_auth VALUES (1,'test','773359240eb9a1d9','80c1b50318676c8f324c985b94ac780a',1013100791);

9. Click "GO" button

This will reset your account to:

User name: test
Password: 123

This same process may work well on other scripts. I'm a newbe to PHP and MySQL so I don't know if Password Encryption is standardized or not.

Regards,

'Buster'

I'm following these instructions, but having problems.

I've followed until this step:

7. In Data Entry field delete "SELECT * FROM `book_auth` WHERE 1"

Which "data entry" field? I don't see any field with this in it.

Furthermore, the information below is THREE lines, so why does it say to paste the two lines? I'm a bit confused and need help ASAP.

8. In Data Entry Field, paste the following two lines:

delete from book_auth;
INSERT INTO book_auth VALUES (1,'test','773359240eb9a1d9','80c1b50318676c8f324c985b94ac780a',1013100791);

Thanks,
Jason Gastrich
JasonG@jcsm.org

Hi Jason,

Sorry I didn't answer sooner. I don't visit this forum very often because AG always works

By data entry field I mean the big white box that says "Run SQL query/queries on database assistsu_agbook1 [Documentation]" right above it.

I still see only two lines (on a 1280X960 display) but paste whatever you see between "delete from book_auth;" and "1013100791);"

Hope this helps.

'Buster'

Jason G wrote:I'm following these instructions, but having problems.

I've followed until this step:

7. In Data Entry field delete "SELECT * FROM `book_auth` WHERE 1"

Which "data entry" field? I don't see any field with this in it.

Furthermore, the information below is THREE lines, so why does it say to paste the two lines? I'm a bit confused and need help ASAP.

8. In Data Entry Field, paste the following two lines:

delete from book_auth;
INSERT INTO book_auth VALUES (1,'test','773359240eb9a1d9','80c1b50318676c8f324c985b94ac780a',1013100791);

Thanks,
Jason Gastrich
JasonG@jcsm.org

Thank you Buster for the info.. I did it and it worked

I think Jason is finding problem with step No 7 because you didn't mention to him to click on the file book_auth in the left so that the statement "SELECT * FROM `book_auth` WHERE 1" appear in the white data entry field.

Regards
The Geologist