How to reset MYSQL root password in Windows if root password is forgotten?

Somehow I have forgotten my MYSQL root password. I tried all possible combination, but everything went in vain, so what the options I have? Either uninstall MYSQL and reinstall it again, since it is just my local development instance or need to figure out a solution to find out the password or change it.

Uninstalling and reinstalling it, is not a wise solution. So other only option is change it. Below are the steps to change the root password for MYSQL in Windows.

1) Log on to your system as Administrator or make sure that you have the administrator privileges.

2) Stop the MYSQL server. To do that, open the Start Menu and type services. It will open the Services window, if not got to the Control Panel > System and Security > Administrative Tools and click Services there. Find the MYSQL services and stop it.

3) Create a text file containing Sql statement to update the root password, save the file in a specific location. Let assume the file is stored in the C drive, and file name is mysql-init.txt 

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

4) Now open the command prompt as Administrator, and go the bin directory of the MYSQL. For me the directory path is "C:\Program Files\MySQL\MySQL Server 8.0\bin"

5) Execute the below command

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

--console  is used to output server logs to the console, that way we know what is happening to the command we have executed.

--defaults-file To figure out the path, go to the services windows, which you performed in Step 2, right click the MYSQL, and click the properties in the popup window, get the data from the path to executable settings

6) Once you executed the command, Start the MYSQL services again.

7) Now login to the MYSQL as root user with the new password.

That's all, you get into the MYSQL.


Happy Programming...!!!


Comments

Post a Comment

Popular posts from this blog

Method Reference in Java Streams

In Java Streams, a method reference is a shorthand notation for a lambda expression representing a specific method. It provides a more concise way to express certain types of lambda expressions. Method references are especially useful when you want to use an existing method as a lambda expression, avoiding unnecessary boilerplate code. There are four types of method references: 1) Reference to Static Method // Lambda expression nameList . stream (). forEach ( s -> System . out . println ( s )); // Method reference nameList . stream (). forEach ( System . out :: println ); 2) Reference to an Instance Method of a particular object: // Lambda expression nameList . stream (). forEach ( s -> members . validate ( s )); // Method reference nameList . stream (). forEach ( members :: validate ); 3) Reference to an Instance Method of an Arbitrary Object of a Particular Type: List < String > countryName = Arrays . asList ( "India" , "America" , "Russia...
Read more

PHP LARAVEL Directory Structure

When you create a fresh laravel project, you will be provided with the following files and directory to start with. Let's walks through the directories one by one.   Directory Description app The app directory contains the core code of your application. Models, controllers, routes all goes in here.     bootstrap The bootstrap directory contains all the bootstrapping scripts (app.php) used for your application. This directory also houses a cache directory which contains framework generated files for performance optimization such as route and service cache files. config The config directory holds all your project configuration files (.config). database The database directory holds your database migrations, models and seeds. public The public directory helps in starting your Laravel project and also holds other scripts (JavaScript and CSS) a...
Read more

PHP LARAVEL - Hello World Laravel

As part of a new assignment, I have started working on Laravel. After completing the setup, I am writing my first program on Laravel. I am not different from other programmers, so I am starting with the basic Hello world, and it works as sanity test to make sure that application has been installed correctly. Let's how we can write Hello World in Laravel. Through Route In your Laravel project, go to routes/web.php file and add the following chunk of code: Route :: get( '/' , function () { return 'Hello World!' ; }); Now open the application in the browser: http://localhost , you can see the Hello World! in the browser. Through Controller Now we will create a new controller with the artisan command: Go to the project root folder through command prompt and execute below the command. php artisan make:controller HelloWorldController Now go to your controller folder /app/Http/Controllers , you can see HelloWorldController.php and add the following function public ...
Read more