mysqld --console --skip-grant-tables --shared-memory Leave this window open. Open .
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_strong_password'; FLUSH PRIVILEGES; EXIT; Stop MySQL service :
C:\Program Files\MySQL\MySQL Server 8.0\bin C:\Program Files\MySQL\MySQL Server 5.7\bin Navigate there or add to PATH. Stop MySQL service (optional but recommended for some versions): change mysql root password windows
Then inside MySQL prompt:
net stop MySQL :
FLUSH PRIVILEGES; ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; EXIT; , then restart MySQL normally:
mysql -u root -p Enter current password. ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'
mysql -u root :
