How to update your WordPress password manually via the database

Easily updating your WordPress password is a crucial step when it comes to securing your website. Have you ever forgotten your WordPress password? Don’t worry, it happens to the best of us. To reset it, you can manually update it via the MySQL / MariaDB database. This can be achieved easily by executing the SQL query provided, after connecting to your WordPress website’s database and replacing the necessary variables. Remember, protecting your WordPress password is key to ensuring the safety and privacy of your website’s content.

SQL Query to update your WordPress Website

Just run the following SQL query to update your password to whatever you need:


update wp_users set user_pass=md5('super-secure-password') where user_login='derekcodes';

Tips for Keeping Your WordPress Password Secure

While updating your WordPress password is essential for security, there are a few other things you can do to keep your password secure. Here are some tips:

  • Use a strong and unique password for your WordPress website.
  • Avoid using common words or phrases in your password.
  • Use a password manager to generate and store your passwords.
  • Install a firewall / brute force detection software plugin
  • Enable two-factor authentication for an extra layer of security.
Share via
Copy link
Powered by Social Snap