sql root password lost

    Hello


    I tried to update to latest version but it always says that my root sql password is wrong.


    How can i correctly change my root sql password when its lost? I always get the error:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


    Thank you

    https://dev.mysql.com/doc/refm…esetting-permissions.html


    if your root user was removed previously, then you can recreate it

    Code
    1. CREATE USER 'root'@'localhost' IDENTIFIED BY 'some_pass';
    2. GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
    3. CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
    4. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    5. FLUSH PRIVILEGES;