upgrading 1.3.0 to 1.3.14 root MYSQL password reset

Hiya,
I'm upgrading from 1.3.0 to 1.3.14 and I've forgotten the mysql root password.

I'm at the upgrade screen where its asking host, port, username and password for Mysql. Can I reset the Mysql root password? I've tried this link but does not seem to work. Once I've done all commands I try to test the new password changes via: mysql -u root -p

I get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

https://debian-administration.…otten_MySQL_root_password

Any help how to continue the upgrade most appreciated. If I cancel the upgrade will it rollback?

Thanks,
Rob

Thanks for the help. My german is pretty bad. Whats the thread talking about? Reset of root mysql password? Do I need to run those commands to reset mine?

Thanks,
Rob

Working thanks all. I ran the SQL query from the post mentioned above in German.

SQL-Query

• # mysql -u debian-sys-maint -p<password>
• > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '<yourpassword>' WITH GRANT OPTION;
• > GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '<yourpassword>' WITH GRANT OPTION;
• > FLUSH PRIVILEGES;
• > \q