how to change user password in phpmyadmin

0 Flares Filament.io 0 Flares ×
Mysql database is widely used now. So its a open source software and wordpress, drupal , etc many open source cms software is based on mysql data base. so you can create the users,tables, using mysql and the data is stored in the database and the admin of the database is done my simple application tool called phpmyadmin. The phpmyadmin is the famous open source tool.
so we can change the password of the users in the phpmyadmin easily and following tutorial will show you
Advantage of this tutorial:
  • You can recover the password even when you forget the email address of the user.
  • You can change any password easily .
Tutorial
  • Login to your phpmyadmin account. you can find you phpmyadmin in your website cpanel
  • Select the Database .
  • php my admin

    phpmyadmin

  • After selecting the database . you will get the details of tables present inside the database.
  • Select the “user ” table , In the user table the login details are present .
  • phpmyadmin users

    database users

  • Select the users table and click on Browse .
  • You can see all the users , Id, email id, password of the database.
  • Click on the particular user to change the password.
change password in phpmyadmin
  • So click on the password and rename the password with new password in text format.
For eg: if you need to change the password into “helloworld” clear the content over there and type “hello world”
  • In Next step, click on the function tab beside the varchar(32) , you will get the drop down menu. So here you have to choose the encryption algorithm MD5
database encryption md5
  • After selecting the Encryption then click on “Go” which is present at the bottom.
  • Hence you password is changed without any email address.
If You have still more queries, drop the comment below . If you like the post keep sharing to your friends :)
0 Flares Twitter 0 Facebook 0 Google+ 0 Filament.io 0 Flares ×

9 thoughts on “how to change user password in phpmyadmin

  1. […] This post was mentioned on Twitter by Emma Robert, Michael Davis, Adrian Lazariuc, Jessica Lynn, Sofia Zoey and others. Sofia Zoey said: RT @sureshpeterss: RT @sureshpeterss how to change user password in phpmyadmin http://bit.ly/eMP7RN #wp #wordpress #bloggers #mysql #php … […]

    • no problem mate :) its a good way to change password if you lost or fogotted :)

      • hi…i am a php beginner with a very little knowledge…i have made a simple login form with php/mysql….the thing is whenever i test it on my localhost(XAMPP)…it always displays on browser “can not select DB”…plz help me brother i am stuck at this point and really need help

  2. Good one with the screeenshots; I have been using phpMyAdmin for almost 12 years now

  3. Thanks a lot for the info. You just saved me reinstalling my entire site because of the lost admin password.

  4. Just to say thanks!
    Clear, simple & accurate guide – helped me a lot
    (i.e. saved my weekend…)

    Best
    Mulli

  5. Very Nice Post, Thanks for Sharing this :)

Leave a Reply

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