I think they mean you should change the password for the guestbook rather than reset your mysql permissions.

Does advanced guestbook allow you to retrieve your password?

If not it seems that support has asked you to look for a config file that would store the password, or check in your database to see if it is stored there.

HTH,

EJ - drop the direction you are heading with the MySQL root password... I doubt it's relevant...

I'm not specifically familiar with the Advanced Guestbook - is this the one installed from cPanel?  Is there a related website/author link somewhere that the original scripts or installation package can be acquired?  That information would be helpful to pursue analysis of the MySQL database structure and SQL abstraction layer that relates to a user and their password.

Your time right now would well  be spent using phpMyAdmin or any other familiar MySQL admin tool to examine the database tables related to this Advanced Guestbook.  Look for a table that contains user information and possibly a password column.  If you find it, most likely the data will be encrypted from an MD5() function... that's OK.  Use your selected MySQL admin tool to update the column value to "5f4dcc3b5aa765d61d8327deb882cf99" which is the MD5 encrypted version of "password"... make sure you note the original value as a precaution.

See where that takes you!

Exactly the right place EJ (best I can tell from your info).

Make the change, press the GO button and then open another browser to confirm you can login to your Advanced Guestbook.

ugh! well its changed it but when I put in "password" it didn't work

yes, Miraenda

then I went to login to admin from guestbook and that is where I put "password"  in password field

OH BLESS YOU, Miraenda! That thread didnt do it but I found another in that forum that did!!!      

I really think this should be a sticky either in how to's or begginers forum, I can't be the first/only person to ever have this problem (or can I? lol)
I used method one and it worked like a charm.


[Method 1]
Login to cpanel
Go to  "MySQL Databases"
At bottom of page click "Click here to access phpMyAdmin."
Select the Guestbook database.
Select book_auth.
Now choose Browse.
You now see the admin username and password.
Select edit.
Now paste Code:

Code:
773359240eb9a1d9

in the password field and click “GO”.

This will reset your account to:

Your admin name and the password will be: 123

you can then change the password in the admin area

--------------------------------------------



[Method 2]
Select the Guestbook database
Now choose on the right side of screen select SQL
Now insert in the Data Entry Field the following lines:

Code:

delete from book_auth;
INSERT INTO book_auth VALUES (1, 'test', '773359240eb9a1d9', '7d8b85294e2e060b83f596a4fc5561ce', 1058460506);


And click "GO"

This will reset your account to:

User name: test
Password: 123
------------------------

I tired this method(2) and couldnt get it to work