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

    Files

    • error.png

      (122.21 kB, downloaded 4 times, last: )

    Edited 4 times, last by robbo007 ().

  • 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