XAMPP MySQL shutdown unexpectedly , Cannot connect: invalid settings.

MySQL said:
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[@inrsr9837]

I am trying to avoid this problem since last 3 days but couldn't find solution. But you solve this problem only 3 minutes great sir 😚😚😚😚😚😚

[@isaacboateng3645]

Oh yes finally, finally, it worked just by deleting those files after I stopped Mysql running on the MySql Notifier

[@metallical87]

So simple yet so effective THANK YOU SIR :D

[@vasishtharamamohan791]

Thankyou you are now greater than my friends

[@ayoubboutarfa5061]

Thank you, I watched so many videos but this one was the ONE!

[@adamstudio254]

Unfortunately, it doesn't work for me ! this is 6th video in a row failing solving my issue. But, in general, it's worth my time. Nice explaining. Keep up !!

[@nathanwilmot8638]

Thank you, a bunch of crappy videos I had to look at before I found yours and finally got it working.

[@senooedu4534]

Thank you friend. I had same issue on my MacBook. I tried may ways they not work but your Simple delete trick work for me. Mac Users: /Applications/XAMPP/xamppfiles/var/mysql and delete all files without folders.

[@hosanamaria9793]

Nem todos os heróis usam capa... muito obrigado amigo, você é um amigo 🤝 acabou de salvar o semestre da faculdade de uma pessoa

[@HariShankarHP]

Extremely effective! Thank you so much for this wonderful tutorial. I had been searching StackOverflow for hours together to see what went wrong, but just deleting those files and restarting xampp MySQL DB helped. Thanks again!

[@hudaabdullah4344]

finally, solved this problem. Thank you so much

[@najmifarhan5768]

Wasted hours trying to figure out the solution. Then you helped me bro. Thank you so much

[@iaguizinho]

finally!!!! so much thanks bro, u was the only one who solved my problem

[@b.sasikumar2141]

I find lots of solutions I didnt get any where i get only from u tnq a lot sir👏👏

[@Rabi-Explorer]

Thanks brother i watched many videos but this one is really helpfullllllll

[@zaynasghermalik]

sir you are a genius! A definite like for your video.

[@user-xj8nd2gi3w]

Very nice!
It's working perfectly.
Good Video

[@manhchui4452]

thank you very much, it worked, i have lost so many time to fix it until i found your email, thanks so much again

[@siphesihlemathe7179]

Thank you so much i wasted 2 days of my project trying to fix this error and nothing worked

[@abhilashshenoy5262]

Worked, Hits up man . My bro has been re installing all the time to get this fixed and I found out the fix through you...

[@rutendomhungu1291]

thanks after a long struggle it worked

[@rainstorm4161]

you save a lot of time for me.thank you 🙏🙏🙏🙏🙏🙏

[@PRIYANKASINGH-vl3wk]

Hi thank you i also face this problem that time i don't know how to fix it but this time i am able to fix it learned from your video
again thank you so much.....

[@balbirbadyal71]

Thank you i have watched so many video.. but no one has said to change port in php.ini
This works...
Thank you

[@swetaks8152]

Omg thank you soooo sooo much it finally work I was uninstalling xampp 1000 times thinking there was a problem there ... Thankew so so much

[@kgatomasala9309]

Thanks my dawg, you’re an OG for that

[@jamesphilipcostales5082]

!!! I've been finding the solution for so long! This was the simplest! Thank you so muchhhhhh

[@harleenkaur717]

Thank you Buddy

[@kaolan9722]

Thankyou very much. I think I already explore the same problem in other videos but ur videos save mine!!

[@EsamHafez]

Thanks a lot that's great, it is very much helpful. we just need to make sure we stop both Apache and MySQL services and start again upon unifying the ports in both files.

[@richardracine9055]

Thank you very much! It worked.

[@datahost3421]

O Thanks man it works properly the first way.

[@abiramisaravanan5496]

It worked ... thanks alot

[@arifulazed8826]

Thanks Stack...worked like a charm..!!!
😎😎🖐🏾✌🏾

[@asr3678]

Thank You Sir
It Actually Worked 🔥🔥🔥🔥🔥🔥

[@bibby8249]

thank you monsieur, arigato gosaimasu

[@faithxevents5013]

you are awesome
but bro you forget to save ibdata1 file cause without that we are not able to open our table of database

[@ut5941]

Oh wow, I've been googling this problem for 2 hours now and none of the suggested solutions worked. This one did. Thank you!

[@HaifengZhu-pn3uq]

I followed your tutorial, still have the error of #2006 - MySQL server has gone away
Open new phpMyAdmin window
Failed to set configured collation connection!

[@phamngoclong617]

Thank you very much!

[@ErenYeager-qh3rl]

Please help me 🥺after deleting it still not works
When I go again to that folder some 8 files have created automatically
And
When I click on admin on (MySQL) the page is opening for first time after that when I click anything (like new or reload) the error(MySQL said : cannot connect invalid settings) is coming please help sir
So I am unable to create a database 😭

[@VY-zt3ph]

Me too.

[@sangeethasandran8533]

Thank you so much, I love you for this video!

[@arycontents]

That works guy Thanks so much!!!

[@aaronchandler4154]

I did this and had nothing but error that I can not fix. I got into phpMyAdmin but something went wrong with the tables where I get error 1932, table does not exist in engine. Would love to know why this crash happens and is there a full-proof fix.

[@mkyky]

Thank you sir, still work.

[@louiezielnono8312]

very helpful, thanks a lot, God bless!!

[@aditisharma5745]

Thank you so much !! I m trying this for so long..

[@user-gk8ew3sw7s]

thank you sir !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!..............................

[@remdon]

Лайк, от души.. Помог. Мучался пару часов с настройкой

[@jhonstonbenjumea9276]

Thank you so much.

[@ziggystardust1866]

It works for now. Thanks a lot man!

[@uditisinha357]

Thank you so much I will cry

[@ssdheeraj6347]

Thank you so much !

[@creepymellowsa]

From Africa where the is no water I thank you

[@rabindramahato6950]

Thanks you sir.

[@user-sv2pm5um3e]

when iam change the port ,there is a massege sound accesed denied,please help me bro

[@ajayshriwas6951]

Very nice guide

[@mohamednouman3560]

bro you saved my live you are the best

[@sinthiaskitchen]

thanks bro

[@phoenixmichaeldotarot2005]

THANK YOU VERY MUCH

[@leosacademy]

It won't work for me. But the method was correct. Mine won't work because my windows Firewall blocking the XAMPP. So, Make sure to disable Firewall or give permission to pass trough Firewall. Thanks!!!!

[@aishwaryadhandore8699]

Thank you so much sir,it's really helpful to me

[@zyggtmoy]

Thank you sir, works like a charm. Only took 2 hours to sort it ...

[@HackerFlavio]

thankyou so much best video ever

[@nimraakram2305]

Thank you for this video.

[@inrsr9837]

Awesome you do it🙏🙏🙏🙏🙏🙏🙏🙏🙏

Thanks so so much!!

[@kimemianjuguna7671]

Thank you so much it worked

[@hassu_by]

Thank you so much ❤️🥰

[@ALL_ONE911]

Thank you so much bro😊😊

[@mohamedmahmoudgueye730]

Very good thanks

[@nadirali754]

Awsome. Your video is too helpful for me.

[@ilgravel]

Thank you! Deleting this file now is all ok

[@draganapetrovic8642]

Thank you so much

[@thevanted99]

thanks man, it worket. I have been working on this problem for quiet a while

[@usamaUzair343]

Thank you my dear may Allah bless you

[@boyzuo]

Thanks. It works for.

[@abdallhmohamed165]

It FINALLY works ! thanks

[@dianrachma6117]

Thankyou so much, so helpful

[@sonedayan980]

Works perfectly for me...Thanks a lot

[@bryanvillalta886]

thank you so much sir

[@chuckythedemon80]

What to click to get the search
I am not getting it

[@navdeepsinghbhati4032]

Super worked fine thanks

[@rajdeep1229]

Thank you....

[@nibeditapradhan2301]

Thank you ... 🙂

[@kausarali9852]

Finally
Thanks

[@dalisomwanza4902]

Thank you bro!

[@vanilmann1203]

Helped!!! Thanks~

[@abdiwahabnoor3571]

thank you very much !!!!!
its realy working

[@thinhhuynh9254]

Thank you

[@boneybv2932]

cheers boss

[@user-rc4xf1tl7i]

brother these are data files by selecting these files we will lost the entire data

[@ShrutiThakur-hb1hs]

Thanks!

[@amirulsyahid3414]

thank you my man, have a good day

[@cosminboglis5160]

Thanks man!

[@kevinrusso7813]

Thanks👍👍👍

[@ErnestoValdezJr]

Thank you sir... this worked like a charm :)

[@themarin1992]

thank you a lot!

[@sumukh483]

thank you so much you saved me

[@neerajvishwakarma4355]

thank you so much sir to resolve my problem