Access Denied root@localhost - Solved - MySQL Server - Windows - Reset Root Password

Подписаться 888

Просмотров 116 тыс.

50% 1

One of the major errors that you get when you newly install mysql server is the access denied for user root@localhost. This can be easily resolved using a simple command.
The command used in the video:
command 1 - ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'
command 2 - mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\\my.ini" --init-file=c:\\mysql-init.txt
Hope your issue is resolved now.
Happy Coding.

Опубликовано:

14 май 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 171

@Zhaxxy 2 года назад

mann ive been stuck on this for hours looking through countless forums and whatnot trying to fix this, but this was the only thing that worked. i only comment on these types of videos rarely and you earned a like from me thanks!!! now i can actually get into this stuff

@ppcuser100 2 года назад

Very helpful, I struggled with this in the internet for 2 hours until see your video :)

@ProdByDL 2 года назад

Thank you very much for this video. I've been trying to get MySQL to work for my computing project, and you may just have helped me greatly.

@chavorrukin 2 года назад

Liking and subbing because this is the only resource that actually helped me change my password. Thank you so very much!

@swarajdey9035 3 года назад

Thanks man it works... Keep going.. I have watched so many vidoes but your one is best ... You deserve more views

@agastya4700 2 года назад

u r video is best dude .... before getting ur video , i have watched too many videos ,but no one was working. but ur video is lifesaver for me.

@Marietta_mathew 2 года назад

Thankyou so much sir! Your instructions were so clear. Please keep doing more of these! Thankyou sir

@paintingmylifeawaify 3 года назад

you are a life saver. only your tutorial seemed to work for me. thank you thank you thank you!

@andyamour 3 года назад

Thanks!!! Helped me a lot after a day seeking for this answer! Just saved the day!

@AjaySingh-iy2th 3 года назад

mysql fml, this worked meaning u saved my life

@afzalkarimtalukdar5543 2 года назад

Thanks. But I had to modify mysql-init file. Basically my content in mysql-init.txt file was: use mysql; update user set authentication_string=password('mypassword') where user='root'; update user set plugin="mysql_native_password" where User='root';

@UnboxedGoodies 7 месяцев назад

I couldn't have done it without you, mate, the actual solution. 👍

@wernervonbraun5385 2 года назад

THANK YOU A LOT MAN! THIS IS REALY HELPFUL

@surendrarakshit6927 2 года назад

Thank you so much, I came up with this error and your video helped me a lot...

@murwaneisa2287 3 года назад

thanks a lot i tried the same steps in other tutorials but it doesn't works,. but now its work thanks to you :)

@kalistams997 3 года назад

Finally worked. Thank you sir

@farihanishat9795 5 месяцев назад

Thankyou so much. After trying for hours, finally your solution worked for me!

@mahimatolani813 9 месяцев назад

I tried all the steps in this video. Also got the same message as shown in video at command prompt. But still when I type the command mysql -u root -p it shows the same error. Not sure what to do now. Please help if anyone have any clue.

@suvetha9414 2 года назад

You're a life saver! Thank you tons! 🥺

@harshgahlot2555 2 года назад

Saved my day. Thanks a lot 🙌

@tasosvaltinos8621 3 года назад

Top stuff! The only real solution I found online!

@demman8081 3 года назад

Great tutorial. Thanks a mil. Great help

@aswanivijayan5899 4 года назад

Sir by mistakely I had given an password in my phpmyadmin xampp server. Now I can't open or start the xampp.

@gwell2118 3 года назад

You life-safer you. Thank you

@robertgul219 2 года назад

Thank you very much, this was very helpful! :)

@dhinakaran9910 Год назад

2023 still its helpfull

@jerichoguillermo8699 Месяц назад

The last part where i enter 'mysql -u root -p' other thing appeared. It said that ''mysql' is not recognized as an internal or external command, operable program or batch file.'

@andrewkepson3055 3 года назад

It works! Thank you so much

@nigeljinivon 3 года назад

thank youuu instruction was so clear

@TuanHuynh-ln3nj 3 года назад

Thank you man

@aniketkumarpandey8809 2 года назад

Thank You so much yaar I was literally very very frustrated man,, Thanks yaar respect*100 for u ...

@hanchloie22 3 года назад

Thanks! It worked for me.

@ilangrynszpan489 Год назад

Thank you very much, you literally saved my day lol.

@Turnpost2552 3 года назад

Mysql is not recognized even though I know I have it installed and at end where is Users/Dell/mysql I dont have that

@electromorphous9567 3 года назад

Freaking amazing!!!!! tysm

@marioleal7183 3 года назад

Thanks! it was very useful, great!

@pritompaul4249 2 года назад

Thanks a lot brother! you are saving my life

@shreyakini9604 3 года назад

After entering the password,command prompt shows plugin caching_sha2_password could not be loaded : Specified model could not be found. Library path is 'caching_sha2_password.dll'. Please Help Me with this.

@davidcastro5778 Год назад

You are a legend, my friend

@ranjithags7925 4 месяца назад

Thank you sir .. issue resolved..

@raulgarcia3619 3 года назад

A master!!! Worked!!!!

@yusufaksoy3693 2 года назад

I got this error because I wrote the wrong password. Thanks for video.

@vikasvk_ 3 года назад

Awesome! Thank you

@sondreauto 3 года назад

Very nice tutorial!

@Alexander-pt1ye 3 года назад

Thank you man!

@Harshith_Chowdary 4 года назад

Bhai 🙆🏾‍♂️ thank you.

@harshraghuwanshi5163 3 года назад

Don't work bro Getting failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' ( OS errno: 2 -No such file or directory).

@safedba 11 месяцев назад

Still not resolved. Data drive is drive D. I shared and unshared the drive and now I can't connect.

@HighTempChaos Год назад

NOTE: If your root password contains a single quote (or potentially other special characters, I only tested with single quotes), this will not fix it, you have to change the password.

@shaikmunsif4381 2 года назад

Thanks, good explanation.

@MichaelMcGlynns 2 месяца назад

Super helpful.

@shwetasawant5744 10 месяцев назад

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) after entering passwrd i can see this error... what to do?

@user-te4wh6tq8t 3 года назад

thank you, it's worked!!

@devinmiester 10 месяцев назад

thank you so much!

@granand 2 года назад

Hi Don, Please can you make a video or give a link on how to load (restore) .bak datasets into SMMS and Dbeaver?

@scarletrot800 Год назад

bro u just saved my life

@silvayunus 3 года назад

RESOLVIDO! Obrigado meu amigo. Depois de dias e muita procura, tentando consertar esse problema, só você resolveu! Obrigado! RESOLVED! Thank you my friend. After days and a lot of searching, trying to fix this problem, only you solved it! Thanks! Brazil#Bolsonaro

@DonHash 3 года назад

Appreciate your feedback.

@saadkhan6290 2 года назад

Bhai love ker gya ha...thank u very much

@anoos2210 Год назад

Thank u so much. You saved my date lot...

@sumbulk.8135 3 года назад

I'm getting this error "mysqld -default file is not recognized as an internal or external command, operable program or batch file". Please help me out!

@DonHash 3 года назад

You need to add mysql to path in environment variables

@jordanstafford5110 2 года назад

still didn't work... --console didn't give me a response either but it's on my path, any idea if this has to do with anything?

@assiabenyetto2296 3 месяца назад

did you find any solution ??!

@jordanstafford5110 3 месяца назад

@@assiabenyetto2296 not really, I ended up wiping the files and starting over. Sorry I didn't follow up. Someday I'll get this stuff down.

@jordanstafford5110 3 месяца назад

@@assiabenyetto2296 Thank you for following up to ask though, it really was considerate of you.

@dhrutijoshi3701 3 года назад

thanksss a lot..its finally working

@naceeramine5241 2 года назад

The most anoying error in life history 🥵🥵🥵🤕🆘🚑

@ofekezra7567 4 года назад

still not working for me , i did every step 3 times and still access denied

@ofekezra7567 4 года назад

Lahiru Hashan ok thanks is worked man i just needed to reinstall mysql

@liveyourlifenow7935 3 года назад

Thank you. But I m install it for the first time and I can't log in what to do

@brunadelmouro8697 3 года назад

Thanks!!! You're great!!!

@user-jg7og2nr6m Год назад

It doesnt work mysqld gives file perrmission error

@rjhammer6092 Год назад

Can u plz help with my SQL I have facing major issue in mysql I saw more than 50 vedios on RU-vid I didn't figure it out .Plzzz help

@diveshthakur5656 3 года назад

Hey bro plzzz help🙏🙏🙏 I have done all the steps correctly but at the end when I open the command prompt and wrote mysql -u root -p Then it is showing this MySQL is not recognised as an internal or external command, operable program or batch file. Plzz help bro... in next week I have a practical plzz

@DonHash 3 года назад

Add mysql to your path at environment variables.

@senaittekie4599 3 года назад

wow , u helped me alot...thankyou

@user-rv5zn6gz9v Год назад

Thank you, helped me)

@karishmanadaf2880 3 года назад

Not working, MySQL default file is not recognised as a internal or external command ,operable program or batch file-error

@hamidkhan2817 3 года назад

Same issue 😭

@francisjayvillas5623 3 года назад

Why It says [ERROR] Failed to open required defaults file: C:\Program Files\MYSQL\MySQL Server 8.0\bin\ [ERROR] Fatal error in defaults handling.Program Aborted! Please Help!