reset root hesla v MySQL

caute,
neviete mi poradit ako by som resetol root heslo a meno (alebo nastavil nove) v MySQL (server bezi na ubuntu 6.06LTS) ked som stratil heslo (aj meno)?

v nastavovani a prevadzkovani MySQL som menej ako zaciatocnik

DIK.

How to Reset a MySQL Password in 5 Easy Steps

1. Stop the mysqld daemon process.
2. Start the mysqld daemon process with the --skip-grant-tables option.
3. Start the mysql client with the -u root option.
4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
5. Execute the FLUSH PRIVILEGES; command.

These steps reset the password for the "root" account to "password". To change the password for a different account, or to set a different password, just edit the variables in single-quotes in step 4.


http://www.tech-faq.com/reset-mysql-password.shtml