Find out where is mysql data directory
'SHOW VARIABLES WHERE Variable_Name LIKE "%dir"'SHOW VARIABLES WHERE Variable_Name = "datadir"'Reset root password on MySQL on Windows 10 laptop
Stop SQL Server Create a text file "mysql-init.txt" in C:\temp directory and paste in this content ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; Open a command prompt window and run this command mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file="C:\\temp\\mysql-init.txt"
Comments
Post a Comment