Admin password hacked..how to reset

[missyera]

Heya admin staff,

Well, i tried browsing through past entries/posts to see if this problem has happened before, but i've yet to find any solution.

Well, it appears that someone has hacked into our admin password and reset it, and now, we couldn't log in to upload anything.

I saw that someone said that one can reset the password thru the phpmyadmin feature on cpanel, but we have no idea how to go about doing it. Is it possible for someone to guide us thru the steps? It would be very much appreciated. Thanks in advance!

the gallery can be found at http://www.mitchel-musso.com/gallery

[Stramm]

phpmyadmin:
-select the cpg db
-browse the coppermine users table
-the admin is usually the first user (id 1), click the edit button
-you'll see a cryptic user_password and before a dropdown box, set the dropdown to MD5 (if the password is plain text, then do not change the dropdown)
-enter a new password

[topmmc]

phpmyadmin:
-select the cpg db
-browse the coppermine users table
-the admin is usually the first user (id 1), click the edit button
-you'll see a cryptic user_password and before a dropdown box, set the dropdown to MD5 (if the password is plain text, then do not change the dropdown)
-enter a new password

You are a life saver, thanks....I locked myself out and now I can access again.