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"; 
FLUSH PRIVILEGES;
 
 
 
Done