thank you very much, finally this worked! been digging and reading in numerous forum before trying your solution. much appreciated, keep up the good works.

Thank you for this! I spent hours searching around for a lot of things that didnt work and this is the one solution that did. You're awesome for this.

Was facing this issue all of a sudden and wasted 5hrs on this.. it worked now.. Thank you so much

Thank you so much bro for solving my problem.I was facing this problem from last so many days. After watching so many tutorials I didn't resolve it....All thanks to you

thank you so much I was trying to fix this issue for hours your solution is the only one that worked for me ♥

Thanks a ton!!! @KaRam It was a wonderful video I was stuck with it since last 3 days Thank you very much and hence subscribed!

@karamtech

Жыл бұрын

Thanks and welcome

I watched more then 5 video... And every time i stop & start my msc service in sql prompt but no one idea is working for me .. your video really help me to fix my root password reset issue before knowing previous password 😊#Thanku

Thanks a lot, this video was really helpful. Hugs from Brazil 🌎

Thank you bro, this video is very useful for me. I was facing this issue from last one week. Now all the issues fixed

Peace! Thank you so much! I spent hours trying to fix this, and this video did it for me.

people like you making this world a good place for living by solving this problems 🙏

Mil gracias amigo, soy de Colombia y hablo español, a pesar de lo lejano me ayudaste mucho Thank you for this!!!!!!!!!!!!!!!!!!!!!!

worked for me in Workbench.. but somehow not with cmd. But its enough for me... Thanks !!

Just performed the steps as is and it worked for me!!! Thank you

After one day its resolved because of you thank you so much budy.. coolest

How was the default password? Before it was not asking for a password to access the database, but now it is

OMG THANK U SO MUCH AAAAAAAAAAH THIS ERROR IS DRIVING ME CRAZY FOR DAYS and now I have another error... I guess the problem is me 😭 But seriously thank u ❤❤

i don't see ready for connection method. What should I do sir?

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.

@SamuelVolder

Жыл бұрын

i did'nt get it, can u explain that?

@HighTempChaos

Жыл бұрын

@@SamuelVolder Maybe it is not like this in all versions, but I originally used a password that had the single quote character ( ' ) in it, for example, 123'ABC. Even when inputted correctly , I was not allowed to log in, and was given the access denied for root user error. Eventually I used a password that did not have a single quote (Such as 123ABC instead of 123'ABC), and there was no longer any issue.

@PiyushKumar-wq2fq

Жыл бұрын

Thanks bro...I have seen many video nobody discuss about it

@CodeWithKav

10 ай бұрын

You are great bro Your idea really solved my problem 🎉😂

@ClipsRandomStuff-wk7ys

8 ай бұрын

bro i fucking love you. Thank you!!

Can you explain the process and why this problem occurred.

Thank you so much sir i was trying to sole this problem for whole nght!

it was great learning from Varun Grover himself 🤗

thank you sir , you helped me lot to fix this issue, the only solution through i got and fixed this

Thank you very much!….i was able to log in at last!

@karamtech

2 ай бұрын

Glad I could help

Does not work!!!!

it is not showing ready for connections, instead of it ,it is showing aborting

Thank you so much, the problem resolved.

Thanks a ton...thaknk youu soo muchh...After many trail...It worked...thanks a lot

The only video that helped ! kudos

I can access mysql workbench but the connection error is showing in intellij

Thank u so much bro....Stucked with this error for long time.....Now it's solved 👍👍

@nobody-eu7kd

Жыл бұрын

Wher to write password

Sir where to write password after root with space?

Thanks a lot sir, it actually help me... Many Many thanks to you

Dear sir hope you are well , Sir i am facing this problem since 3 days but still this problem is not solved, can you help ltipleme? please Sir I have watched your videos for a long time but still not reslove .

Eu fiquei buscando a solução por tanto tempo, meu Deus do céu!! Voce me ajudou tanto!!!

Guuuuuyyyysss!!!! It worked finally 🎉🎉😢 Thank you so much ❤

@karamtech

4 күн бұрын

Happy to help you

Upgrade xampp reading datadir from the mariadb server failed

Thanks a lot brother ❤, awesome video😊

Its. Showing me shut down complete In place of ready to connection ??? Please help me out

@MrDeveloper-cp3pg

Жыл бұрын

Im also getting the same error. Can you help me bro getting out of this...??

@ISHANP-qy9wu

Жыл бұрын

@@MrDeveloper-cp3pgsame thing i get it from last few hours but now it show ready for connection but after that the problem is not resolved

Thanks...now I have resolved issue..

thank you so much It literally worked 100%😀😀😀😀😀😀😀

Can you solve this problem in vs code?

In hidden files...i am not able to see problem data

Hello sir tried everything but still getting same error

My problem is that it shows " access denied for user 'root'@'localhost'. Account is locked

Actually im getting same error while running springboot project

You are a genius!!!!!!!!!! Appreciate it

I'm still facing this error 2024-06-19T10:28:06.254529Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\ProgramData\MySQL\MySQL Server 8.0\Data\mysqld_tmp_file_case_insensitive_test.lower-test 2024-06-19T10:28:06.254669Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 936 2024-06-19T10:28:06.268697Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\ProgramData\MySQL\MySQL Server 8.0\Data\mysqld_tmp_file_case_insensitive_test.lower-test 2024-06-19T10:28:06.268901Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\ProgramData\MySQL\MySQL Server 8.0\Data\mysqld_tmp_file_case_insensitive_test.lower-test 2024-06-19T10:28:06.269450Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\ProgramData\MySQL\MySQL Server 8.0\Data\' (OS errno: 13 - Permission denied) 2024-06-19T10:28:06.269851Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-06-19T10:28:06.270098Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.37) MySQL Community Server - GPL.

@SKNGaMeRzZ

25 күн бұрын

same error as me now u fix it? how tell me

is this only applicable for localhost ?

Yes Issue is resolved very helpful to full video

I think this method is genuine but it won't worked for me idk why? but something is wrong with my pc i am quite sure about it.

THANK YOU, I FUCKING LOVE YOU GENIUS, SAVED ME TONS OF WORK

access denied for schema public

/****************/ For those no method worked just reset the MYsql password and set new password Then put new password in your vscode php file.

I spent a lot of time and it did not work

Thank you so much. You are the best

Failed to open .ini file

How can i Fix " access denied for user 'root'@'localhost' (using password: NO) " in MySQL

Thanks a lot🎉🎉 this video help me lot

how to rollback man.

I don't have my name in databases...

Still the same thing.

Access denied for user 'root'@'localhost' (using password: NO) is it work for it?"

Thanks a lot, it worked 👍

Still not solved

best video my problem is solved

cd C:\Program Files\MySQL\MySQL Server 8.0\bin 1) stop mysql 2) mysqld --skip-grant-tables 3) mysql -uroot -p 4) ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; 5) FLUSH PRIVILEGES; 6) start mysql

Mysql is such a pain, Sql Server is so much better

It works..Thank you

Thanks a lot it worked 🎉👍

Thank you so much brother ❤❤❤🎉

Best bro it worked..

mysql does not recognized...

@samyajitt

Жыл бұрын

Same:(

@vaishnavimhaske3337

Жыл бұрын

Same

Lovely bro❤️

Thank you so much, video was really helpful🦾🦾

Thank you so much

Thank you👍👍

Too many arguments (first extra is 'init-file=c:\\mysql-init.txt'). ??? am i bricked i acidenttly deleted local host cus i thought my php was breeched smh deleted myself

Thanks a lot brother!

Thanks for this solution.

real SE.....hattsoffff was stuck for the whole damn day.............

@karamtech

9 ай бұрын

Glad it helps

Thank yuhh so much...

Yes bro I solved it🔥

Thank you so much 👍👍

thank you man

Great Bhai..

Thankyouuuu very much

ThX Man!!!!!!!

Tq so much 🥰🤩

👍

Thank you bro

Thanks bro

thank u

thanks brother

I want to gift you my car!!! you have removed the most annoying bug that took 2 hours of mine

@karamtech

10 ай бұрын

😁😁😁

@FruityHachi

8 ай бұрын

2 hours that's nothing, I'm on my second day and still nothing works

@avanimittal8330

8 ай бұрын

@@FruityHachi sad to hear that.

Thanks

thank you so much

thanks my bro

Magic!

I LOVE YOU