If above process to reser mysql root password did not worked, my client adviced also this one and used these commands:
Code:
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD(“PASSWORD”) where User=’root’; flush privileges;
this just change the users password, but I couldnt login to 'root'@'localhost' so with this I could succesfully remove the password:
Code:
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password');
It changes [email protected] pass, now i dont have problem
--------------
Do you have any experience yourself? Or another ways on how to reset password?
---
To change password, not reset it, one do: mysqladmin -u root -p'oldpassword' password newpass
Bookmarks