June 7, 2012

reset mysql root password

ps -ef | grep mysql      - checks if mysql/mysqld is one of the running processes. 
pkill mysqld             - kills the daemon, if it is running.
mysqld_safe --skip-grant-tables & - Run MySQL safe daemon with skipping grant tables
mysql -u root mysql - Login to MySQL as root with no password
UPDATE user SET password=PASSWORD("your-new-passowrd") WHERE user="root"; 

No comments:

Post a Comment