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
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!