Change the Root password in MySQL or MariaDB on Windows Server

Reset the Root user password in MySQL or MariaDB on the Window platform

  1. Create an empty file with the name change password in C: drive or any other location.

2. Edit the file and enter in the later command as follows and save the file:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';

3. Open the services.msc and stop the MySQL service.

4. Right-click on MySQL80 services and get the path from where the service running and its default in the file location

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" MySQL80

5. Open the cmd and run the command as follows to change the password:

cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
mysqld --init-file=C:\\changepassword.txt

6. If you have some default configuration then run as otherwise start the service and try to login with a new password; Start the service that already includes the default file. The following command is not needed to execute:

mysqld.exe --init-file=C:\\mysql-init.txt --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" MySQL80

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.