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

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

Embed JSX code with if condition in React app