To reset other user password you need to login as a root from the command prompt.
However you can reset your own password without logging as a root user

First you need to login from command promt.

# Mysql -u <user> -p //Example: Mysql -u root -p
Enter Password:


Now you need to set set password command to set new password.

mysql> SET PASSWORD = PASSWORD(‘abcder’);

To reset other user password use the syntex:

mysql> SET PASSWORD FOR ‘krishna’@’%’ = PASSWORD(‘abcder’);

All you have done!

Written by Bala Krishna

Bala Krishna is web developer and occasional blogger from Bhopal, MP, India. He like to share idea, issue he face while working with the code.