Reset SQL root password (or any other user)

use --init-file to start it up with:
UPDATE mysql.user SET Password=PASSWORD('<new password>') WHERE User='<user>';
FLUSH PRIVILEGES;
Afterwards, delete the init file.