Posted on

Change Coppermine 1.6x Password via phpmyadmin

This is the short, sweet and quick version. This is for NEWER versions of Coppermine, all versions 1.6 and later. For versions BEFORE 1.6 please visit this post (please note you SHOULD upgrade your coppermine to 1.6x as soon as possible to prevent hacks/etc.

1. Sign into cpanel (which you can do via the client section here(on stars.bz) or via the regular /cpanel url)
2. Click on phpmyadmin
3. Find the username(what you use to sign in to your cpanel with), to the right and click the little ‘x’ to expand the databases.
4. Click on the database you use for your coppermine.
5. Click on the _users table (should have something before the _, whatever you chose to title the tables)
6. Find your username or the user under group_id 1(which is the administrator group id)
7. Click ‘Edit’ which is beside of a pencil next to this username
8. Find ‘user_password’, in the drop down menu select MD5 and type in any password you want to set it as in the text field beside the dropdown.
9. Find the ‘user_password_salt’ and erase everything in the field.
10. Find ‘user_password_hash_algorithm’ and erase everything in the field. (I usually do this as an extra measure)
11. Scroll down until you see a new set of two dropdown menus. One says save and the other should say ‘Go back to previous page’. Below those two is a button that says ‘Go’. Click that ‘Go’ button.
10. Sign in with the new password you set (the password you set in step 8 which will be the actual password not the MD5 code once you save).
11. Give yourself a pat on the back for a job well done.

If this tutorial helped you, please consider buying me a coffee using Ko-Fi.