How to change WordPress password using phpmyadmin

Have you forgotten your WordPress password or lost access to your admin account? Don’t worry! In this guide, we’ll show you how to change your WordPress password using phpMyAdmin quickly and safely. You can also watch our step-by-step tutorial video below.

Step 1: Log in to your cPanel

1. Open your hosting account and log in to cPanel.
2. Scroll down to the Databases section and click phpMyAdmin.

Step 2: Select Your WordPress Database

1. In phpMyAdmin, find the database associated with your WordPress site.
2. Click on the database name to view all tables.

Step 3: Open the wp_users Table

1. Look for the table named wp_users. The prefix may vary if you changed it during installation.
2. Click Browse to see all WordPress users.

Step 4: Edit Your User Password

1. Find the row with your WordPress username.
2. Click Edit.
3. In the user_pass field, select MD5 from the function dropdown.
4. Enter your new password in the Value field.

Step 5: Save Changes and Log In

1. Click Go or Save to update the password.
2. Now, go to your WordPress login page and log in with your new password.

Tips & Precautions

• Always back up your database before making changes.
• Use a strong, secure password with letters, numbers, and symbols.
• Only use this method if you cannot reset via email.

Conclusion / CTA

Changing your WordPress password using phpMyAdmin is safe if done carefully.

If you want hosting optimized for WordPress with automatic updates, backups, and security, check out HostCry WordPress Hosting Plans.