Metalik
November 26th, 2010, 16:02
Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords
mysqld_safe –skip-grant-tables
mysql –user=root mysql
update user set Password=PASSWORD(‘new-password’) where user=’root’;
flush privileges;
exit;
Now kill your running mysqld, then restart it normally
mysqld_safe –skip-grant-tables
mysql –user=root mysql
update user set Password=PASSWORD(‘new-password’) where user=’root’;
flush privileges;
exit;
Now kill your running mysqld, then restart it normally