SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass'); FLUSH PRIVILEGES; use mysql; update user set authentication_string=PASSWORD("mynewpassword") where User='root'; flush privileges; quit ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd'; exit;# Mysql 8 ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '0RO3R0T9XHS0ZWRR'; FLUSH PRIVILEGES; EXIT; mysql -u root -p