MySQL Forgotten Root password reset

In this video, I have explained the process for resetting the root password for MySQL. for resetting the root password I have used a txt file where I have mentioned the command
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yournewpassword';
and executed the below command on CMD with run as administrator on My sql installation path C:\Program Files\MySQL\MySQL Server 8.1\bin\
Command
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.1\my.ini" --init-file=C:\
eset.txt
after few seconds just press Ctrl + c and try to access your MySQL with new password which is written in your txt file.
Post changing your password you can delete the reset.txt file for security reason.
#windows11
#windows10
#windows
#windows11mix
#mysql
#mysqldba #databasemanagementsystem
#windows

Пікірлер: 47

  • @jeremydavidson7559
    @jeremydavidson75594 күн бұрын

    this works thanks! had me frustrated for awhile

  • @InfoAlias

    @InfoAlias

    3 күн бұрын

    Good to know... 👍

  • @user-ds8jn5zc4n
    @user-ds8jn5zc4n8 ай бұрын

    It really works, thanks bro 👍

  • @InfoAlias

    @InfoAlias

    8 ай бұрын

    Welcome 👍 and good to know your problem has been fixed please subscribe and share with others....

  • @basvanzutphen5750
    @basvanzutphen57504 ай бұрын

    Thank you Sir! I succesfully changed my root password

  • @InfoAlias

    @InfoAlias

    3 ай бұрын

    Happy to help

  • @srivi24
    @srivi243 ай бұрын

    Thank you so much sir!

  • @InfoAlias

    @InfoAlias

    3 ай бұрын

    Thanks for watching this, kindly share with others and subscribe

  • @TheHimalayanBuddy
    @TheHimalayanBuddy11 ай бұрын

    Very useful..👍👍

  • @InfoAlias

    @InfoAlias

    11 ай бұрын

    Thanks a lot

  • @viniemeralda3395
    @viniemeralda3395Ай бұрын

    THANK YOU VERY MUCHH SIR I HAVE ASSIGNMENT THAT NEED TO BE COMPLETED IN 3 HOURS THIS IS REALLY HELPFUL

  • @InfoAlias

    @InfoAlias

    Ай бұрын

    Best of luck for your assignment........................

  • @TharinduUdakara
    @TharinduUdakaraАй бұрын

    Thank you!

  • @InfoAlias

    @InfoAlias

    Ай бұрын

    Thanks for watching this video. Kindly share with others.

  • @DaniilZelikov
    @DaniilZelikov3 ай бұрын

    👍👍👍

  • @yonastesfaye5737
    @yonastesfaye57375 ай бұрын

    thank you so much

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    Thanks for watching. Please share with your friends and please subscribe for upcoming tech videos

  • @prithvisingh40
    @prithvisingh404 ай бұрын

    thanks sir

  • @InfoAlias

    @InfoAlias

    4 ай бұрын

    Most welcome, please subscribe and share with others

  • @rizkigunawan7946
    @rizkigunawan79462 ай бұрын

    thanks

  • @InfoAlias

    @InfoAlias

    2 ай бұрын

    You're welcome! Good know your issue has been fixed. Kindly subscribe and share with others.

  • @shloksamudre9981
    @shloksamudre998110 ай бұрын

    Thanks a lot

  • @InfoAlias

    @InfoAlias

    10 ай бұрын

    Happy to help, Please share with others as well for subscribing my channel.

  • @vadlamudirakesh9967
    @vadlamudirakesh99675 ай бұрын

    Create root password doesn't show me when i install my sql workbench now the database connection also not established now it shows connection error ,Now how to connect database connection to my work bench and root password also i didnt create root password while instal work bench

  • @etc_sushantdhavane9448

    @etc_sushantdhavane9448

    5 ай бұрын

    same problem

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    Can you share the MySQL installation path from your system

  • @bronwynrojas5134
    @bronwynrojas51344 ай бұрын

    Mine still doesnt work :/ It says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" even though i typed in the new password correctly

  • @InfoAlias

    @InfoAlias

    4 ай бұрын

    Hope you have stopped service and doing it these whole process with admin account, watch this video from begining only

  • @zahramustafa5656

    @zahramustafa5656

    2 ай бұрын

    Same issue, can you please help, I followed the entire process

  • @NarutoUzumaki-mg8yd

    @NarutoUzumaki-mg8yd

    2 ай бұрын

    same issue pls help

  • @InfoAlias

    @InfoAlias

    2 ай бұрын

    @@zahramustafa5656 follow the instructions carefully, this will work and its tested

  • @InfoAlias

    @InfoAlias

    4 күн бұрын

    You need to open the cmd with run as administrator

  • @prashantkumar-ek3im
    @prashantkumar-ek3im8 ай бұрын

    "C:\Program Files\MySQL\MySQL Server 8.0\bin\Mysqld" MySQL (My path to executable is showing only this portion ......)

  • @InfoAlias

    @InfoAlias

    8 ай бұрын

    Watch the complete video carefully. This should be similar like in this video. Try to copy the path from service this is what I did in this video.. Thanks

  • @user-yy4ij8vn5n
    @user-yy4ij8vn5n5 ай бұрын

    Its showing this "Access denied for user error 1045" How to solve this

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    Check Account Permissions: Verify that the service is configured to run under an account with the necessary permissions. If the account lacks the required privileges, it might result in the service failure.

  • @riddhijadav6196
    @riddhijadav61965 ай бұрын

    In services me can't show mysql8.0 then what should I do?

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    Can you please share the path exactly from service

  • @riddhijadav6196

    @riddhijadav6196

    5 ай бұрын

    C:\ProgramData\MySOL\MySQL Server 8.0 and it's already show that exists

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    Please watch the video carefully , this will fix your issue, Even you can read the description of this video as well, @@riddhijadav6196

  • @DorivalAfonsoCardoso

    @DorivalAfonsoCardoso

    9 күн бұрын

    dont worked in my mysql8.0 too.. :(

  • @Ritu-TheWinner
    @Ritu-TheWinner5 ай бұрын

    C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld--defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file=C:\ eset.txt 'mysqld--defaults-file' is not recognized as an internal or external command, operable program or batch file. Could you pls help...thx in advance

  • @InfoAlias

    @InfoAlias

    5 ай бұрын

    there is a space between mysqld and --defaults, Just go through the description and perform the task accordingly.

  • @DorivalAfonsoCardoso
    @DorivalAfonsoCardoso9 күн бұрын

    dont worked in my mysql8.0

  • @InfoAlias

    @InfoAlias

    8 күн бұрын

    try to follow the complete steps . This will work for 8.0 as well.

  • @sahilkadecha9831
    @sahilkadecha98314 ай бұрын

    not working

  • @InfoAlias

    @InfoAlias

    4 ай бұрын

    tell me the error

Келесі