How to Change Blog Password Using phpMyAdmin on cPanel

Changing your WordPress login password, should be easy using the “Lost your password?” feature.

However, if you don’t own the default email of the blog the only way to change an unknown password is through phpMyAdmin on the cPanel. This guide is for cPanel’s using the new “Paper Lantern” theme.

Note: The “Paper Lantern” is the new default theme for cPanel. The old x3 theme is now deprecated although it was replaced by the similar looking interface called “Retro“.

Here’s how change your password the nerd way.

1Login to your cPanel account. For most webhost, the login url for your cPanel is normally in this format: http://yourdomainname.com/cpanel

login to cPanel

2Find phpMyAdmin It’s under “Databases” box.

phpMyAdmin

3Click the phpMyAdmin It will open on a new tab/window.

4Now, if it is asking for a username and password, leave the page open then go and get the blog’s default database username and password by following this tutorial: “How to Get the Default Database Name and Password

If it redirects immediately you to the phpMyAdmin page without asking for username and password, then proceed to step 5.

phpmyre

5On the phpMyAdmin page, click on the database name of the blog you want to change password.

phpmyd

Your database table looks like this:

6Look for “wp_users” table and click it.

wp users

7On the right panel, you’ll see the wp_users table. Click “Edit” link.

editname

Your expanded wp_users table looks like this:

wp users table

Now, as you can see from the table above, you can change several data here like the user_login, user_pass, user_nicename, user_email, user_url, user_registered, and display_name.

8For this, demo we’ll just change your username and password.

user login only

9Type your desired username in user_login field.

user login name

10On user_pass field, click empty field to show hidden menu then choose “MD5″ from the drop down menu.

choose md5

11Now, delete that ugly lookin’ characters and type your new password.

scpsp

12After typing your new password, click the “GO” button below to save your changes.

go now

13Review the changes you made.

yesesyo

14You should now be able to enter your blog with the new password (and username) you have created using phpMyAdmin on your cPanel.

Sometimes even after changing your password using this method you’ll find out that you can’t login still. If this happens, just simplify your password (for temporary use only).

Don’t include special characters yet like +,!,#,@,*,~,and ?. For example, just use abc123 or your name or any simple word.

After you are successfully logged in to your WordPress dashboard, you can then change your password and make a stronger one by going to Users => Profile => New Password

NOTE: You may download this tutorial by clicking here.

You May Also Like