Strategic Marketing Academy - Marketing for Event Industry Professionals

SMA offers marketing services and training for event businesses and small businesses in other industries

  • Home
  • Services
    • Strategic Planning
    • Website Design
    • Local Search
    • Local Citation Building
    • Search Engine Optimization
    • Social Media
    • Blogging
    • Video Marketing
    • Press Releases
    • Reputation Management
    • Pay Per Click (PPC) Marketing
    • Conversion Optimization
    • Mobile Marketing
    • Tracking And Analytics
  • Training
    • Home Study Programs
    • Marketing Webinars
    • Marketing Workshops
  • Testimonials
  • Blog
  • About Us
  • Contact Us

How to Reset a WordPress Password from phpMyAdmin

April 5, 2015 By Katerina Williamson Leave a Comment

Knowing how to reset your WordPress password from phpMyAdmin is one of the essential things you should know about because for some reason if your site is hacked, or something else, you are no longer able to login to your admin panel using the login information, and you are not able to reset the password via email, this method can be very useful.  We often have to deal with this issue in our clients’ accounts so we hope this blog post helps you when you are faced with the same task.

Every WordPress blog uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using cPanel hosting. Follow the following steps to reset your WordPress password:

Step 1 – Identify the Name of your Database

It is always good to know the name of your WordPress Database. Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password. The best place to look is your wp-config.php file which is located in your root WordPress Directory. In there you will find the name of your database.

Step 2 – Locating Database and Editing the Fields

In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.

phpmyadmin

Once you are in phpMyAdmin, you will need to select the correct database on the left hand side. Look for the name that you found in your wp-config.php and click on that. You will see a list of tables with a prefix wp_ for the most part.

If you changed your prefix during installation, then you would be looking for that specific prefix “for ex: wp673_”.

You will look for the table wp_users, click on it and then click on the Browse Tab.

resetpassword1

 

Click on the Pencil (Edit) Icon to reset your Password.

resetpassword2

 

Now you will see a field that looks like this:

resetpassword3

Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text.

This means that you will not be able to enter plain text as the password. You would need to use one of the MD5 generators online to generate your password.

Recommended Tool: JavaScript MD5

Simply type your password in that tool and generate MD5 results. Copy and paste the code you get from the converter into your phpMyAdmin field and click Go to save changes.

You have now successfully changed your WordPress Password from phpMyAdmin.

Filed Under: Website Design Tagged With: database, Wordpress

Leave a Reply Cancel reply

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

Recent Posts

Best Local Citations For Event Rental Businesses

How to Effectively Create Great Content for SEO

Six Strategies of Increasing Exposure on Social Media Using Hashtags

The 19-Point On-Site SEO Checklist

A Complete Guide To Business Social Media Etiquette [Infographic]

Topics

  • Blogging
  • Direct Mail
  • Email Marketing
  • Event Business Startups
  • Marketing Planning
  • Mobile Marketing
  • Networking
  • News & Thoughts
  • Online Marketing
  • Paid Online Advertising
  • Print Advertising
  • Referral Marketing
  • Reputation Management
  • SEO
  • Social Media
  • Trade Shows
  • Video Marketing
  • Website Design

Recent Posts

  • Best Local Citations For Event Rental Businesses
  • How to Effectively Create Great Content for SEO
  • Six Strategies of Increasing Exposure on Social Media Using Hashtags
  • The 19-Point On-Site SEO Checklist
  • A Complete Guide To Business Social Media Etiquette [Infographic]

See The Results!

Services

  • Strategic Marketing Planning
  • Website Design
  • Local Search Marketing
  • Search Engine Marketing
  • Search Engine Optimization
  • Social Media Marketing
  • Blogging
  • Video Marketing
  • Online PR
  • Online Reputation Management
  • Pay Per Click (PPC) Marketing
  • Conversion Optimization
  • Mobile Marketing
  • Tracking And Website Analytics

Copyright © 2025 Strategic Marketing Academy - Google

Google+