Change password mysql 8 - haiquang9994/dev_env GitHub Wiki

in skip-grant-tables mode

UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;

in mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';