Monday 28 June 2010

Mysql : Reset root password 

service mysql stop
mysqld_safe --skip-grant-tables &
mysql -uroot mysql 
	UPDATE user SET password=PASSWORD("abcd") WHERE user="root"; 
	FLUSH PRIVILEGES;
mysql -uroot -pabcd mysql

Posted by Ook at 06:42

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)