{"id":380,"date":"2024-06-13T18:56:21","date_gmt":"2024-06-13T18:56:21","guid":{"rendered":"https:\/\/zalvis.com\/docs\/?p=380"},"modified":"2024-06-13T19:01:23","modified_gmt":"2024-06-13T19:01:23","slug":"how-to-reset-wordpress-password-via-phpmyadmin","status":"publish","type":"post","link":"https:\/\/zalvis.com\/docs\/how-to-reset-wordpress-password-via-phpmyadmin.html","title":{"rendered":"How to Reset WordPress Password via phpMyAdmin"},"content":{"rendered":"

If you ever encounter an issue logging in to your WordPress dashboard due to an invalid or forgotten password, there is a neat trick to reset it from your cPanel area, specifically phpMyAdmin.<\/p>\n

So for those who have never heard of phpMyAdmin, here\u2019s a brief description on how it works and what it\u2019s for:<\/p>\n

In order to create a functional website, most developers use databases to store website information. There are various kinds of databases but one of the most popular types is MySQL. Now this is where phpMyAdmin comes in. It is created as a piece of software written in the PHP programming language that is used to handle MySQL administration.<\/p>\n

In other words, phpMyAdmin helps you to manage MySQL databases such as database creation, performing database queries, table management, and so on. This also means that it can also help you to view and manage tables that store your website data, including your WordPress users and passwords.<\/p>\n

Follow the steps below to change your WordPress admin password from phpMyAdmin:<\/p>\n

    \n
  1. Login to your cPanel area Once logged in, type in phpMyAdmin on the top right search bar or just scroll down until you can find the phpMyAdmin option.\"\"<\/li>\n<\/ol>\n

     <\/p>\n

      \n
    1. Choosing the correct WordPress database, select the \u201c_users\u201d table, and edit the admin user row<\/li>\n<\/ol>\n

      Once the phpMyAdmin interface opens, click on your WordPress database on the left hand pane. If there are multiple databases within your cPanel account, make sure to choose the correct one. Then select the \u201cwp_users\u201d table. Depending on the database prefix you are using, the name of this table could vary. In the screenshot below, for example, we are selecting the \u201cwpro_users\u201d. Afterward, click the \u201cEdit\u201d button on the WordPress user you wish to reset the password of.<\/p>\n

      \"\"<\/span><\/span><\/p>\n

        \n
      1. Inputting the new password<\/li>\n<\/ol>\n

        Now there will be several fields you can edit in this particular table row, such as the user name, email address, or password. To set a new password for this user, go to the \u201cuser_pass\u201d column, set the \u201cFunction\u201d to \u201cMD5\u201d and input the new passphrase on the \u201cValue\u201d field accordingly. Then, click Go and wait for the change to be processed and saved.<\/p>\n

        \"\"<\/span><\/span><\/p>\n

          \n
        1. Login to WP admin area<\/li>\n<\/ol>\n

          To make sure that the new password has been set properly, login to your website\u2019s WP admin area and use the passphrase you just set on the database.<\/p>\n

          \"\"<\/span><\/span>If you are still having issues logging in, go over Step 2 and 3 again and double-check if you selected the correct database\/WordPress user.<\/p>\n

          If you enjoyed this article, then you\u2019ll love Zalvis's Cloud Hosting platform. Turbocharge your website and get 24\/7 support from our veteran team. Our world-class hosting infrastructure focuses on auto-scaling, performance, and security. Let us show you the Zalvis difference! Check out our services.<\/a><\/div>