Greetings micfo members,

Its easy to reset the password of MySQL by going inside the MySQL prompt but what if the MySQL command doesn’t take inside mysql prompt?

Well in that case just fire following command and you will be able to reset the MySQL password.

first locate your MySQL ’s hostname.pid file then

kill `cat /mysql-data-directory/host_name.pid`
mysqld_safe –skip-grant-tables &
mysqladmin -u root flush-privileges password “newpassword”

New password will be the password that you want to set now.

Enjoy …