How to Change Password Wordpress Phpmyadmin (2025)

If you've lost access to your WordPress site and can't reset your password via email, you can change it directly in the database with phpMyAdmin. Here's how to do it in a few simple steps.

1. Access phpMyAdmin

a) Connect to your host

1. Log in to your hosting account (e.g. cPanel, Plesk or another control panel).
2. Look for the phpMyAdmin and click on it.

b) Find the WordPress database

1. In phpMyAdmin, locate the menu on the left and select the database for your WordPress site.
2. If you don't know which database is used, consult the file wp-config.php in your FTP. Look for the line :define('DB_NAME', 'your_base_name');

2. Change WordPress password

a) Accessing the user table

1. In your database, find the wp_users (or a different prefix depending on your configuration).
2. Click on Browse to see the list of users.

b) Change password

1. Find the line corresponding to your administrator account.
2. Click on Edit.
3. Locate the column user_pass.
4. In the ValueEnter your new password.
5. In the Functionchoose MD5 to encrypt the password.
6. Click on Run to validate changes.

3. Reconnect to WordPress

Once you have made your changes, return to your site's login page (your-site.com/wp-login.php) and use the new password to access your dashboard.

Conclusion

Changing your WordPress password with phpMyAdmin is a quick and efficient solution when you can't use the email reset function. However, for security reasons, we recommend that you change your password again from within the WordPress interface, and activate two-factor authentication if possible.

Need more tips for securing your WordPress site? Check out our guides and stay protected!