How to reset password and username for WordPress if you cannot login

How to reset password and username for WordPress if you cannot login

This is very often people ask me about resetting their WordPress user password or username. In general you cannot change the username of WordPress username, but if you edit the database, you can do that. Well the process is easy, if you follow the following steps.

Login to your cPanel: To login to your cPanel enter http://yourdomain.com:2082 or http://yourdomain.com/cPanel. You’ll get a page like the picture below.

cPanel Login
cPanel Login

 

Search for phpmyadmin: to the top-left corner there’s a search box, type phpmyadmin there & you’ll find the phpmyadmin. You can also look through the page to find it. Now click on phpmyadmin.

phpmyadmin
phpmyadmin

 

Select the database you want to edit: From the left panel select the database you want to edit. If you have more than one database, and you’re confused about which database to edit, just go to File Manager from your cPanel and edit wp-config.php, there you’ll find the database name.

Database List
Database List

 

Select wp_users table: Now, when you select your database, you’ll see a list of tables in the left side bar. Select wp_users from the table.

Table List
Table List

 

Click Edit on the user you want to edit: Once you select wp_users, you’ll see a list of users in the right side, just click Edit on the user you want to edit.

User List
User List

 

Now it’s time to edit the username & password: Now you’ll see a list of fields there you’ll find user_login and user_pass. If you want to edit the Username only, just change the username. But if you need to change the password first select MD5 like the picture below, and now type the password you want to set for the user. Remember, you must select MD5, otherwise it’ll not work.

Change Username &/or Password
Change Username &/or Password

Now you’re all set, just click GO (you’ll find it below the form).

If you like the post, please share with your friends. And if you like my blog, you can join the fan page to get the latest updates. And obviously I suggest you to email subscribe through the form given at the top right corner to get the latest updates into your mail box, oh, I don’t spam.

13 thoughts on “How to reset password and username for WordPress if you cannot login

    • Thanks for your comment. I’m planning to write on the topics I feel people need. If you want any particular help, you can visit my blog’s fan page & ask me questions there. I’ll try my level best to help you.

      Thanks again.

  1. I am using wordpress for longtime. And sometimes i forget my user id and password for login. I remember, i removed whole database to login to wordpress when i forget the password and user id. But by applying this trick i can easily edit the user name and password. Thanks bro for this types of information . Keep going ……….

    • Dear boomwala, I hope you’ll not need to delete all your database to do that from now on. Thanks for your comment, this will encourage me to write more on different topic.

      Keep visiting my blog, I hope you’ll find lot more info like this.

  2. ভাই জান আপনার ব্লগ সাইটটি দেখলাম। আপনার সাইটির Presentation আমার কাছে অনেক ভালো লেগেছে। সাইটটিতে content এখনো কম তবে অনেক বিস্তারিত আর ভালোভাবে লেখা। চালিয়ে জান।


    Translated by Admin:
    Dear brother, I’ve seen your blog. I like the presentation of your blog. Though the content is limited on this blog, but they are descriptive and well structured. Keep it up.

    • Dear Tanvir Hasan,
      Thans for your comment. I’ve just started my blog on March 1, 2013. And trying my best post as much post as I can. And obviously I’m trying my best to put descriptive and important/interesting matters on my blog. I hope you’ll keep visiting my blog.

  3. নাইস ব্রো , আপনার ব্লগ টি আগেও ছিল কিন্তু মাঝে কিছুদিন ৪০৪ ইরর দেখাত । তাইনা ? আবার লাইভ দেখতে পেরে ভাল লাগল । চালিয়ে যান , সাথে আছি ।
    Translated by Admin———————————————————————————–
    Nice bro, I saw your blog previously, but for some days I found it showing 404 error. Isn’t it? I’m glad to see it live again. Keep going, I’m with you.

    • Dear AKM Borhanice, thanks for the comment and wish. Yeah my blog was offline for someday. From now on, I’m trying my best to keep it alive. Thanks for being with me.

Leave a Reply

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