How to Reset MySQL Root Password on Windows

Подписаться 102 тыс.

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

50% 1

Upgrade your Clever Techie learning experience:
/ clevertechie
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:
/ 20811657
The proper way to reset your MySQL root password on windows if you have forgotten your root password.

Хобби

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

21 авг 2016

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

7 years passed and this video still works

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

Extremely thank you for being straight for the straight 5minutes.

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

Another cool way to open the command prompt with the desired path is to navigate to the folder with "Windows Explorer", then type "cmd" in the "Address bar".

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

thank you so much, cmd was not an option for me. It kept giving me power shell

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

@@edgargonzaga5849 Really?! That's interesting! I guess powershell will work. lol. You're welcome, by the way. :)

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

Thanks so much, it was really helpful, mysql manuals didn't say anything about stopping sqld process, so with your instructions I could progress in my issue!

@williamdickinson165 5 лет назад

Thanks for this. Not sure if it applies to anyone else, but I had to put the name of my service ( if it's different than default) after the string my.ini. The way I found it was to just right click on the service in windows click properties and it will give you the full command listed above. Thanks for the help!

@allenvarughese1163 Год назад

yes this worked. thanx.. just a note :The appropriate --defaults-file setting can be found using the Services Manager: From the Start menu, select Control Panel, then Administrative Tools, then Services. Find the MySQL service in the list, right-click it, and choose the Properties option. The Path to executable field contains the --defaults-file setting. (source mysql site)

@saumyathakur2913 6 лет назад

my heartful thx to u fr this video!!!...finally i will get back to my mysql aftr a stretch of straight 6 months...

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

if it shows windows powershell or you can't find the Directory path to the *BIN* folder, try this without the double quotes: 1. open command prompt 2. type in: pushd "path"(Note: no double quotes!!!!!!)

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

Thanks a lot

@zenoboi6162 5 лет назад

Finally got what I wanted :-) Thanks man!!

@johnn4314 5 лет назад

Does anyone know what is the best general computers course to take before programming. I am really into the coding but I don't feel I really understand computers enough

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

this is my issue, please help me out when i input the code in, this happens ;- [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory) Im using the newer function which is the ALTER one. still this error is coming.

@nmaleppanavar 5 лет назад

I cannot find bin folder. I open the location wher I installed MYSQL workbench but there is not bin folder

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

same .. mere me v nhi h

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

how did it work for you when you had mispellings in your script

@douglas5097 6 лет назад

It worked! Thanks for the video! By the way, what " Flush Privileges" really mean? Because you didn't write correctly and worked for you anyway.

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

Douglas Fünkler how to identify root directory in windows

@nilupulheshan27 5 лет назад

Thank you its perfectly worked make sure to type MYSQLD int the CMD

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

hmm you got typo with FLUSH PRIVILEGES .-.

@dev_christian 5 лет назад

Year 2018 and still works. Thanks a lot man!

@micaelalopez8218 6 лет назад

Hello, I have a little problem, when i want to open de my_printS_Defaults , the file closet suddenly and I dont know why?

@GambiarrasDeUmDev 7 лет назад

Excelent video! Thank you so much! Also, Mysql errors logs could be really helpful.

@howawwe3291 Год назад

Does powershell work the same way as the command prompt for this?

@yagzyalcntas553 6 лет назад

there is no mysql in ProgramData folder?? but i downloaded mamp and my server is working and i can make operations on phpmyadmin?

@alexandermayorgamunoz175 5 лет назад

Hi guys. Please help me. I installed mariadb. I dont have my.ini file, instead of I have these files : my.cnf, my-huge.ini, my-large.ini, my-medium.ini, my-small.ini, my-innodb-heavy-4G.ini. So which one file should I use? I need to restart the password . Thanks.

@Maxitom 7 лет назад

I have opened a new window of command prompt, and this is the full line that is being entered after it says "C:\WINDOWS\system32>" C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini" --init-file=C: eset.txt Then it gives me the error "'C:\Program' is not recognized as an internal or external command, operable program or batch file." any help please?

@vaibhavkamani7479 5 лет назад

[ERROR] mysqld: empty value for 'table_open_cache' specified Please help me fix this

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

Can we only create the folder of reset txt using drive? Because I tried to create the folder without drive and it’s not opening for me to write any text inside

@granand 5 лет назад

I get this error when I type in the said command in Command Prompt (Admin) ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

@karengohsh1711 7 лет назад

My roort directory is c:\Windows, does that mean that the reset.txt has to reside here?

@ssteveab 5 лет назад

Thanks for the video. Got a blank screen after entering the init script in the terminal, but it still worked afterwards. Probably some bug on my end.

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

please consider to fix FLUSH statement inside reset.txt cause appearly there is an syntax mistake. best regards.

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

Thanks a lot! You have just saved my life :)

@krisnyreen 7 лет назад

Thanks for the video. Worked perfectly.

@MZSabrinaRJ 7 лет назад

Oh my goodness. Thank you soooo much. I had almost given up hope.

@clevertechie 7 лет назад

You're welcome :)

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

SQL server is not showing on services section. Now How can I resolve the issue.

@domulko44 5 лет назад

FYI if you write your password in mysql and it crashes it doesnt mean that your password is incorrect but that service mysql(number) wasnt set to automatic start :) For those who had same problem as me :)

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

Hi, i've already set it to automatic, but still crashing :(

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

seems like i have to uninstall and reinstall mysql....i have this error mysqld: [ERROR] Found option without preceding group in config file C:\\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe at line 1. (my path to executable defaults-file path is as such)

@PuneetRaj-nc2kj 4 года назад

If you people have a option coming of start in services, click start and then run again the application. It worked for me.

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

Thank you so much... This worked for mysql 5.5 the ini file is in program files... And the message displayed is different

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

Sir. In my MySQL bin any file is not supporting for opening with cmdwhat can I do now?

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

Brother can you help me personally.. I'm having some problem during installation of mysql and they are asking about root password.. but i don't know what's my password was cause for some reason I uninstalled mysql.. and now I don't remember the password and i can't install now

@bineesha.n6329 2 года назад

bro i dont have bin file at '2:00 ' can you tell me where can i find it ?

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

It shows below 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 Suggestion [3,General]: The command mysqld was not found, but does exist in the current location. Windows PowerShell does not load commands from the current location by default. If you trust this command, instead type: ".\mysqld". See "get-help about_Command_Precedence" for more details.

@jijoyshyjo5373 Год назад

4:32 the thing you said would show up didn't show up what i i supposed to do now?

@NagenderGiri 6 лет назад

Thanks man, It really worked. Appreciated.

@jineshkumar3570 6 лет назад

it's good sir can i run more than one mySql on same windows

@RubyKnight1089 6 лет назад

I do not understand Why is there the file called 'ruby' in 2:38!!!

@ridhamjain2728 7 лет назад

what will be process in Windows 7???

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

Finally I can reset my password!! Thank you so much

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

i was able to fix my mysql by watching video thanks man

@mohammedirfanahmed6101 6 лет назад

please help me i can't find "my.ini" file in program data folder

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

check this link....dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html

@tejasadiga_music 6 лет назад

But there is no file called my.ini in my server at all.. Not even in all files..... Can u please help me with that.

@80edays 6 лет назад

On MySQL 5.5. the my.ini file is located at C:\Program Files\MySQL\MySQL Server 5.5\my.ini and the output of the mysqld command is different but it works also fine, thank you so much! ... by the way, I used "FLUSH PRIVILEGES" ;)

@zimou333 5 лет назад

Thank you

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

ok but for MySQL 8.0 where the my.ini file is located please..help me

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

@@CHAKRAVARTHIJOGA same question.. plz can u help me.. agar aapka problem solve hua hoga to??

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

tysm br0ther

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

hello there i have mysql 8.0 and i followed your steps but after hitting enter it dosen't make any thing and brings me back to mysql bin path ? what should i do?

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

I am in the same situation now. Did you find a solution?

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

Me too did you find a solution?

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

@@thetruthsayer8347 I deleted mysql and installed again

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

@@punk4639 ah, I’ll try it

@jerry-mv1qq 2 года назад

how to reset the password if you are using xampp which mysql already installed with it and it I can't follow your step 'cause I can't find my "my.ini"

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

Can you tell me from where you get this wallpaper 😁

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

Instead of "Open command window here" I get "Open PowerShell window here" option and after clicking on that 'Window PowerShell' pops up. So if I write the following code you have written on the command prompt is there any issue? and after that for using mysql password related works should I have to use 'Powershell window' instead of command prompt always??

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

Facing the same issue

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

@@kratikajain5637 just write cmd in that powershell window

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

I'm still hung up on this issue.. Powers hell pops up. It tells me that sqld isn't found but it's there.... Oh my goodness

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

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"

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

Did u find any solution for this error? Even I'm getting the same error

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

@@pyariunnisabegummd6701 I solved the problem with different way. This is more simple and easier. Check out the follow link: stackoverflow.com/questions/60475356/mysql-getting-error-while-changing-root-password

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

@@juanyang838 Do you know what can I do if I forgot my password (and that's the reason why I'm trying to restore my password)?

@alexandramostovaya7865 5 лет назад

I have Windows 10 and MySQL 8.0. Unfortunately, your advice doesn't work! I wrote all commands in CMD and after pushed "Enter" nothing happened. Could you help me?

@rajatgalar2668 5 лет назад

Same thing happened with me

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

Hey this will not work in my laptop mysql: [ERROR] unknown variable 'init-file=C: eset.txt'. this is the error plz help me.

@sivasaivighneshmandava5349 5 лет назад

I didnt find my.ini file in program data folder...plz help

@KunChannel__ 6 лет назад

Worked for me .. Thank you so much

@hallsofivy128 7 лет назад

Hi @Clever Techie, i followed the exact procedure you mentioned in this tutorial. This is the error message i get in cmd: After hitting enter tab 2017-07-22 11:50:55 4356 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. 2017-07-22 11:50:55 4356 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 1000 ... Since in my case my "MYSQL" is an integrated part of XAMPP, i tried to kill the process in task manager i found no mysql.exe running task. Could u help me fix this? Thanks.

@sarthakasthana20 7 лет назад

didn't worked for me .... getting cmd error Fatal error in default handling... can you help me with this error.

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

At 4:26 i get error. mysqld: [ERROR] Failed to open required defaults file: (the directory of my.ini) mysqld: [ERROR] Fatal error in defaults handling. Program aborted! Help me i dont know what to do?

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

Hi bud i've followed the instructions and still no good. ive teamviewer really need your help

@nafissadik 6 лет назад

Thank you so much! Worked for me!

@rajpradhann202 7 лет назад

"fatal error for default handling"this error is displaying

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

@Gabriel A. Nuñez thanx man

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

Mine was rejecting the password I'd set when installing MySql. After using this method it now starting working with the password I initially set. Thanks alot fam

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

did it work for MYSQL80? I am doing the same process and the CMD just stalls.

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

@@tusharverma2439 if you fine a way in mysql80 please tell me I'm going crazy!

@PrinceKumar-eb8hd 6 лет назад

i did not got the my.ini folder.pls reply fast

@stevewaibel5878 6 лет назад

This worked for me, thanks.

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

it shows nothing again goes to the bin directory and thats it can someone help me out on this please

@srpopo5951 Год назад

Thank you man, this helped me a lot

@amandasandu7365 7 лет назад

I don't have my.ini folder in program data\MYSQL folder

@Justplay10_10 7 лет назад

hi, this video help me alot, ty for using basic english for this video rofl, i'm from peru, see ya

@clevertechie 7 лет назад

No problem!

@johnn4314 5 лет назад

im terrible. I couldnt even get the dang text file on the root C: directory. It only takes folders it says

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

create the text file on your desktop and then move it to your root C: directory.

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

hello ...i uninstall mysql and install it again but their showing give current root password and i forget password ....how can i solve this problem

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

Thanks man.you saved my 20 marks :-)

@Its.deep2005 2 года назад

hehe assesmant is really important :)

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

Excelent!! all working now. Gracias

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

it is showing that mysqld command in not recognized. how do i resolve this issue?

@tinashetim6898 6 лет назад

sound is clear...thank you

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

Thanks you. The command didn´t make an output but it worked.

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

same with me, still works in 2020.

@fawadafzal7988 6 лет назад

if it is not working , then search services and right click mysql and run it ,then run mysql command line and enter your password and try to run it , it worked for me

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

what should i do if i have written exactly but still i get an error

@rajeshchandak9218 7 лет назад

It worked! Thanks much.

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

What is the localhost directory?

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

Hi Clever Techie, Is this will work for MySQL Workbench 8

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

i can not do it

@tiaguetzz8135 7 лет назад

i cant find the mysqld.exe to end help me please

@Prasadraja07 6 лет назад

Thanks dr, its help me to sort the issue..

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

Can u tell that setting of you task ar pls

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

There is no MySQL server 8.0 folder in "program data folder = MySQL " There is only MySQL Installer for Windows How to deal with it .. ?????

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

at 4:23 i got error as this 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. now what should i do know???? please help

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

Same.. Did you find ant other way?

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

@@gameaim1059 no..

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

Hey , thanks for the video, when typing in the command. the command isn't doing anything :(

@jaseelabeevis3387 5 лет назад

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

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

Mine too!

@Sprite-od4xl 2 года назад

same error, did you solved that problem?

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

unknown variable 'init-file=E: eset.txt'

@kaaviyabaskaran1041 5 лет назад

how to find out where is the reset.txt folder

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

I couldn't find the option OPEN COMMAND WINDOW HERE in (2.10). If anyone has the solution plz help me out

@syedazran8481 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

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

Same

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

OMG!! This worked so well!! Thanks a lot!

@clevertechie Год назад

No problem!

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

password kept failing, turns out that's because MySQL aint running ! I just right click > running, it's now fixed! I did not know anything about the Service prompt Thanks for your video!