How to reset MySQL password from command prompt

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:

mysql>

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!