How to Reset MySQL Root Password on Windows



Upgrade your Clever Techie learning experience:

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments – easy to learn and understand code
2. Weekly source code file updates by Clever Techie – every time I learn new things about a topic I will add it to the source file and let you know about the update – keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments – skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary – memorize and review previously learned code faster
4. Organized file structure – access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace – no more searching around for previously covered material and source code – save enormous amount of time and effort
5. Outline of topics the source file covers – fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples – interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie

Download the fix here if the reset doesn’t work for you:

The proper way to reset your MySQL root password on windows if you have forgotten your root password.

Nguồn: https://svdpch.org/

Xem thêm bài viết khác: https://svdpch.org/cong-nghe/

22 thoughts on “How to Reset MySQL Root Password on Windows”

  1. OOOOOOOOOOOOOOhhhhhhhh !!!!!! My Good !!!! Thanks a lot. I finally got access. I send you an Iberico acorn ham from Spain;)

    Reply
  2. this is the notify i have got..(shutdown complete mysql enterprise server – commercial) what i have to do now

    Reply
  3. For MYSQL8 it works with

    USE mysql;

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

    FLUSH PRIVILEGES;

    Reply
  4. This kind of error i get after typeing the code in Windows Power Shell

    mysqld : The term 'mysqld' is not recognized as the name of a cmdlet, function, script file, or operable program.

    Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

    At line:1 char:1

    + mysqld –defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my. …

    + ~~~~~~

    + CategoryInfo : ObjectNotFound: (mysqld:String) [], CommandNotFoundException

    + FullyQualifiedErrorId : CommandNotFoundException

    Reply
  5. it's not working any more..

    try same process but change the code of reset.txt ==> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

    and it's work perfectly..

    Reply
  6. is this trick not working on Powershell? I have this error:
    "mysqld : The term 'mysqld' is not recognized as the name of a cmdlet, function, script file, or operable program.

    Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

    At line:1 char:1

    + mysqld –defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my. …

    + ~~~~~~

    + CategoryInfo : ObjectNotFound: (mysqld:String) [], CommandNotFoundException

    + FullyQualifiedErrorId : CommandNotFoundException"

    Reply

Leave a Comment