Skip to content

Change password mysql 8

Nguyễn Hải Quang edited this page Dec 7, 2022 · 1 revision

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';

Clone this wiki locally