How To Change Encrypted Passwords In Mysql

November 7th, 2012 | No Comments | Posted in Php & MySql

Have you forgotten your password in mysql. No problem!

Many users and new programmers are facing the problem of password forgotten. If you know the way to recover the password then no problem and if you are able to do that then no problem . If you don’t know the problem then I will going to guide you the solution of this problem.If you are using mysql database.

Password encryption is the process of securing the password that no one can see and recognize the password in open eyes . Some time

plain text password are used instead of  encrypted password.Password encryption is the process of converting the plain password to user not readable format and the conversion of the encrypted  password to plain text is called the password decryption.

Suppose you want to login as a normal user or an administrator using Mysql database but your password is showing invalid or you have forgotten the password.

To recover the password follow the following steps

Step 1: Type  localhost in the browser or type localhost/xampp or wamp

Step 2: Go to phpmyadmin at the bottom of the left.

Step 3: You can see list of databases. Open the database which is connected with your project

Step 4: Browse the table user or admin user table (The table which contain contain the user information it may be normal user and admin user ).

Step 5 : Edit the row of which password should be change or look for the user name whose password have to change.

Step 6:  Edit the row and change the password

Step 7: Now Select MD5 from the function drop down menu showing left of the password field

Step 8 : Save the record by pressing go or save button.

Step 9 : Now login with the new password

Note: After changing the password you have to change its function to MD5 otherwise it will not take effect.


Leave a Reply 160 views, 2 so far today |

Most Commented Posts

Leave a Reply

Refresh Image