Resetting MySQL root password

[Guest_imported]

Hello,

How can we reset the forgotten root password?
Can we change PRIVILEGES of a mysql user other than by root

 

[cluelessNewbie]

The second question I won't touch.
To the first question:

Do you have root to the machine?
If so... When this happened to me I (no one told me mysql root when they left *sob*) I did a google for the same problem & found this...
1) Shut down the mysqld
2) Restarted mysqld with the --skip-grant-tables option
3) logged into mysql as root w/o password
$ mysql -u root mysql
4) did the following:
mysql> UPDATE user SET Password=PASSWORD('mynewpassword') WHERE User='root';
5) flushed the privileges with:
mysql> FLUSH PRIVILEGES;
6) logged out
7) restarted the mysqld

there are other ways

 

[dozier]

Great piece of advice there, worked great.