pritdeveloper/reset root MySQL password.md

## reset root MySQL password.md

      
    Raw
  

              reset root MySQL password.md
            
          
    How to reset root MySQL password on Ubuntu

sudo mysql -u root
FLUSH PRIVILEGES;
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
# For older mysql
# UPDATE user SET authentication_string=PASSWORD("Secret#123") WHERE User='root';
# not needed
# UPDATE user SET plugin="mysql_native_password" WHERE User='root';
quit