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.

Пікірлер: 190

  • @ayoubboutarfa5061
    @ayoubboutarfa50612 жыл бұрын

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

  • @metallical87
    @metallical872 жыл бұрын

    So simple yet so effective THANK YOU SIR :D

  • @HariShankarHP
    @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!

  • @iaguizinho
    @iaguizinho2 жыл бұрын

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

  • @abhilashshenoy5262
    @abhilashshenoy52622 жыл бұрын

    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...

  • @kaolan9722
    @kaolan97223 жыл бұрын

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

  • @nathanwilmot8638
    @nathanwilmot86383 жыл бұрын

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

  • @aaronchandler4154
    @aaronchandler415410 ай бұрын

    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.

  • @kgatomasala9309
    @kgatomasala93092 жыл бұрын

    Thanks my dawg, you’re an OG for that

  • @jamesphilipcostales5082
    @jamesphilipcostales50822 жыл бұрын

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

  • @arifulazed8826
    @arifulazed88263 жыл бұрын

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

  • @EsamHafez
    @EsamHafez2 жыл бұрын

    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.

  • @najmifarhan5768
    @najmifarhan5768 Жыл бұрын

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

  • @jessicanathania5718
    @jessicanathania57183 жыл бұрын

    i got 403 forbidden after i did this :( any solution? should i just reinsttal xampp

  • @hosanamaria9793
    @hosanamaria9793 Жыл бұрын

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

  • @zyggtmoy
    @zyggtmoy3 жыл бұрын

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

  • @louiezielnono8312
    @louiezielnono83123 жыл бұрын

    very helpful, thanks a lot, God bless!!

  • @inrsr9837
    @inrsr98372 жыл бұрын

    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 😚😚😚😚😚😚

  • @user-sv2pm5um3e
    @user-sv2pm5um3eАй бұрын

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

  • @chuckythedemon80
    @chuckythedemon80 Жыл бұрын

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

  • @b.sasikumar2141
    @b.sasikumar21412 жыл бұрын

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

  • @vasishtharamamohan791
    @vasishtharamamohan7913 ай бұрын

    Thankyou you are now greater than my friends

  • @HaifengZhu-pn3uq
    @HaifengZhu-pn3uq5 ай бұрын

    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!

  • @ErnestoValdezJr
    @ErnestoValdezJr2 жыл бұрын

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

  • @ziggystardust1866
    @ziggystardust18663 жыл бұрын

    It works for now. Thanks a lot man!

  • @adamstudio254
    @adamstudio2542 жыл бұрын

    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 !!

  • @Rabi-Explorer
    @Rabi-Explorer8 ай бұрын

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

  • @zaynasghermalik
    @zaynasghermalik7 ай бұрын

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

  • @sangeethasandran8533
    @sangeethasandran8533 Жыл бұрын

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

  • @richardracine9055
    @richardracine9055 Жыл бұрын

    Thank you very much! It worked.

  • @swetaks8152
    @swetaks81522 жыл бұрын

    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

  • @hudaabdullah4344
    @hudaabdullah43442 ай бұрын

    finally, solved this problem. Thank you so much

  • @hassu_by
    @hassu_by2 жыл бұрын

    Thank you so much ❤️🥰

  • @nikhilsharma2155
    @nikhilsharma21552 жыл бұрын

    no it's not working in my system can you help me out

  • @user-xj8nd2gi3w
    @user-xj8nd2gi3w8 ай бұрын

    Very nice! It's working perfectly. Good Video

  • @PRIYANKASINGH-vl3wk
    @PRIYANKASINGH-vl3wk2 жыл бұрын

    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.....

  • @aditisharma5745
    @aditisharma57452 жыл бұрын

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

  • @aishwaryadhandore8699
    @aishwaryadhandore86992 жыл бұрын

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

  • @ganbaatarjambalsuren4903
    @ganbaatarjambalsuren49033 жыл бұрын

    Thank you so much it works for me

  • @manhchui4452
    @manhchui44523 ай бұрын

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

  • 2 жыл бұрын

    Thanks so so much!!

  • @rutendomhungu1291
    @rutendomhungu12912 жыл бұрын

    thanks after a long struggle it worked

  • @phamngoclong617
    @phamngoclong6172 жыл бұрын

    Thank you very much!

  • @nadirali754
    @nadirali7543 жыл бұрын

    Awsome. Your video is too helpful for me.

  • @arycontents
    @arycontents Жыл бұрын

    That works guy Thanks so much!!!

  • @sonedayan980
    @sonedayan9803 жыл бұрын

    Works perfectly for me...Thanks a lot

  • @ssdheeraj6347
    @ssdheeraj6347 Жыл бұрын

    Thank you so much !

  • @balbirbadyal71
    @balbirbadyal712 жыл бұрын

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

  • @ErenYeager-qh3rl
    @ErenYeager-qh3rl3 жыл бұрын

    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

    @VY-zt3ph

    3 жыл бұрын

    Me too.

  • @thevanted99
    @thevanted993 жыл бұрын

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

  • @gideoncephas5803
    @gideoncephas58032 жыл бұрын

    Thank you so much.

  • @datahost3421
    @datahost3421 Жыл бұрын

    O Thanks man it works properly the first way.

  • @bryanvillalta886
    @bryanvillalta8862 жыл бұрын

    thank you so much sir

  • @harleenkaur717
    @harleenkaur7172 жыл бұрын

    Thank you Buddy

  • @rainstorm4161
    @rainstorm41616 ай бұрын

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

  • @shubhamyache7867
    @shubhamyache78672 жыл бұрын

    Thank you... It actually worked 🔥🔥

  • @vanilmann1203
    @vanilmann1203 Жыл бұрын

    Helped!!! Thanks~

  • @senooedu4534
    @senooedu45342 жыл бұрын

    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.

  • @nimraakram2305
    @nimraakram23052 жыл бұрын

    Thank you for this video.

  • @mohamednouman3560
    @mohamednouman35602 жыл бұрын

    bro you saved my live you are the best

  • @ut5941
    @ut59413 жыл бұрын

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

  • @syrapalo7761
    @syrapalo77612 жыл бұрын

    THANK YOU VERY MUCH SIR!!! IT WORKED!

  • @HackerFlavio
    @HackerFlavio2 жыл бұрын

    thankyou so much best video ever

  • @dianrachma6117
    @dianrachma61172 жыл бұрын

    Thankyou so much, so helpful

  • @ALL_ONE911
    @ALL_ONE9113 жыл бұрын

    Thank you so much bro😊😊

  • @isaacboateng3645
    @isaacboateng36452 жыл бұрын

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

  • @dalisomwanza4902
    @dalisomwanza49022 жыл бұрын

    Thank you bro!

  • @CreativeMedia2k18
    @CreativeMedia2k18 Жыл бұрын

    thank u very much broo

  • @rabindramahato6950
    @rabindramahato69502 жыл бұрын

    Thanks you sir.

  • @yesno5286
    @yesno5286 Жыл бұрын

    i deleted the content but it still dosent work :(

  • @remdon
    @remdon Жыл бұрын

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

  • @asr3678
    @asr36782 жыл бұрын

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

  • @phoenixmichaeldotarot2005
    @phoenixmichaeldotarot20052 жыл бұрын

    THANK YOU VERY MUCH

  • @zeeshanahmadzeeshanahmad7014
    @zeeshanahmadzeeshanahmad70143 жыл бұрын

    thank you it worked perfectly for me :)

  • @amirulsyahid3414
    @amirulsyahid34142 жыл бұрын

    thank you my man, have a good day

  • @yoosufazhar4787
    @yoosufazhar4787 Жыл бұрын

    thanks bro, really very helpful :)

  • @swapnalighadigaonkar8952
    @swapnalighadigaonkar89522 жыл бұрын

    Thanks a lot for your help🙂

  • @draganapetrovic8642
    @draganapetrovic86429 ай бұрын

    Thank you so much

  • @neerajvishwakarma4355
    @neerajvishwakarma43553 жыл бұрын

    thank you so much sir to resolve my problem

  • @kimemianjuguna7671
    @kimemianjuguna76712 жыл бұрын

    Thank you so much it worked

  • @abdiwahabnoor3571
    @abdiwahabnoor35712 жыл бұрын

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

  • @VY-zt3ph
    @VY-zt3ph3 жыл бұрын

    Still not working.

  • @linaboug9883
    @linaboug98833 жыл бұрын

    Thank youuuuu Life saverrr ❤️❤️❤️❤️❤️❤️❤️❤️❤️

  • @mkyky
    @mkyky Жыл бұрын

    Thank you sir, still work.

  • @sumukh483
    @sumukh483 Жыл бұрын

    thank you so much you saved me

  • @cosminboglis5160
    @cosminboglis5160 Жыл бұрын

    Thanks man!

  • @faithxevents5013
    @faithxevents50132 жыл бұрын

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

  • @user-rc4xf1tl7i
    @user-rc4xf1tl7i6 ай бұрын

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

  • @mahimachavan3060
    @mahimachavan30603 жыл бұрын

    THANK YOU SO MUCH!!!!!

  • @inrsr9837
    @inrsr98372 жыл бұрын

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

  • @troxkor7360
    @troxkor73602 жыл бұрын

    bro, i'm really thank with you, you safe me :)

  • @Arifiew
    @Arifiew2 жыл бұрын

    thanks bro , i like it

  • @boyzuo
    @boyzuo3 жыл бұрын

    Thanks. It works for.

  • @hrishirajvlogs7916
    @hrishirajvlogs79163 жыл бұрын

    thank you sir

  • @ephraimdanielvillegas2040
    @ephraimdanielvillegas20403 жыл бұрын

    FINALLY I LOVE YOU!

  • @abbiejillcaceres153
    @abbiejillcaceres153 Жыл бұрын

    It helps a lot... thank youuuu

  • @gauravpandey1454
    @gauravpandey14543 жыл бұрын

    thanks so much its great to see this solution

  • @themarin1992
    @themarin19922 жыл бұрын

    thank you a lot!

  • @Zeegi
    @Zeegi Жыл бұрын

    You said search here but where do we need to click? Why do you tell half half man

  • @stackequation

    @stackequation

    Жыл бұрын

    use Ctrl + F to open the find box to search for default port

  • @abdallhmohamed165
    @abdallhmohamed1653 жыл бұрын

    It FINALLY works ! thanks

Келесі