• Home
  • About Us
  • Archives
  • Contact Us
  • Privacy Policy
  • Copyright Policy

Free Tech Tutors

Useful Tips, Tricks And Tutorials

  • Android
  • Windows
  • Software
  • Software Testing
  • Web Application
  • Web Development
    • Blogger
    • WordPress
You are here: Home / WordPress / How To Change WordPress Password Easily Using phpMyAdmin

How To Change WordPress Password Easily Using phpMyAdmin

June 23, 2015 by Sathishkumar Varatharajan Leave a Comment

If you are WordPress blogger or webmaster, then chances are that you might face a situation where you would need to reset your administrator password. If you know your email address, then you could easily reset the password. But if for some reasons (hacking, deleted email account, etc.,) you can’t access your email, then you can’t reset your password easily. In such situations, you will change WordPress password using phpMyAdmin.

Let’s find out how you can change (reset) WordPress password using phpMyAdmin.

Change WordPress Password Using phpMyAdmin

Change WordPress Password Easily Using phpMyAdmin:

1) To get started, log into your cPanel. To access your cPanel, enter any one of the following URL in your address bar:

yourdomain.com/cpanel or yourdomain.com:2082

Once you enter the above URL, you will be presented with your cPanel login screen. Enter your cPanel username and password and log into your web server control panel.

Log Into cPanel For Changing WordPress Password

2) Once you have logged into cPanel, scroll down to “Databases” section. There you will see “phpMyAdmin” option. Click on it.

phpMyAdmin In cPanel Databases

3) Now, you will see a page with the message “The system will redirect you in a moment“. Wait until you are redirected to phpMyAdmin database administration tool.

Redirecting From cPanel To phpMyAdmin

4) Once you are redirected to phpMyAdmin, you will see your database name along with some other settings as well. Just click on your database name to access its tables.

phpMyAdmin Database

5) Now, you will see the list of tables under your WordPress website database. Click on “wp_users” table to access it rows.

WP Users Table In WordPress Database

6) Under “wp_users” table, there will be only one row if you have only one user. Click on “Edit” as shown in the picture below to change (reset) your WordPress password.

Editing WordPress Password In Database

7) Now, you will see your WordPress username, WordPress password, WordPress administrator email, User registered time, etc. To edit your Password, go to “Value” column in the row “user_pass” and enter your new WordPress password. Once done, choose “md5” under “Function” column in the same row and then click on “Go”.

Change WordPress Password By Editing Database In phpMyAdmin

8) That’s it. Now you have successfully changed your WordPress password. You can follow the same procedure to change WordPress username and WordPress administrator email.

If you encounter any issues while following this tutorial, or if you have any queries regarding this tutorial, do let me know via comments.

Related Posts:

  • How To Install WordPress Using FTP ClientHow To Install WordPress Using FTP Client
  • How To Bulk Delete Categories In Your WordPress BlogHow To Bulk Delete Categories In Your WordPress Blog
  • How To Fix HTTP Error While Uploading Images In WordPressHow To Fix HTTP Error While Uploading Images In WordPress
  • How To Change Gravatar In WordPressHow To Change Gravatar In WordPress
  • How To Install WordPress Using cPanelHow To Install WordPress Using cPanel
Our Reader Score
[Total: 0 Average: 0]
Share
Tweet
0 Shares

Filed Under: WordPress

About Sathishkumar Varatharajan

Sathishkumar Varatharajan is a blogger, internet marketer, business consultant and the owner of Free Tech Tutors. You can connect with him at @sathishkumaratr!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Subscribe

Subscribe with us to get useful software tutorials and web application tips getting delivered directly to your email inbox!

Connect With Us

Visit Us On FacebookVisit Us On TwitterVisit Us On GooglePlusVisit Us On PinterestVisit Us On YoutubeVisit Us On LinkedinCheck Our Feed

Recent Tutorials

  • How To Turn Off Windows 10 Lock Screen Ads?
  • How To Bring Back The Quick Launch Bar In Windows?
  • How To Add An Application To The Quick Launch Menu In Windows?
  • How To Change A Computer’s Mac Address In Windows?
  • How To Defragment The Disk In Windows 7?
  • How To Pin Command Prompt With Admin Rights To Windows Start Menu?
  • How To Add Take Ownership To Right-Click Menu In Windows?
  • How To Add Control Panel To Windows Right Click Menu?
  • How To Change Computer’s IP Address From Command Prompt?
  • How To Set A Custom Startup Folder In Windows File Explorer?

Popular Tutorials

  • How To Change The Background Of a Photo Using Photoshop CS6?
  • How To Remove Watermarks From Photos Using Photoshop CS6 ?
  • How To Delete A Virtual Hard Disk In Windows?
  • How To Download And Install ShareIt On Windows PC?
  • How To Password Protect A Folder In Windows 10?
  • How To Resolve IP Address Conflict Error In Windows 7?
  • How To Type In Tamil In MS Word
  • How To Install Android Apps On Windows PC
  • How To Get Windows 10 Start Menu In Windows 7?
  • How To Create A NTFS Partition In Your Hard Disk

Copyright © 2019 · Free Tech Tutors · All Rights Reserved ®