Error mysql shutdown unexpectedly

Ошибка была вызвана двумя причинами:

1) Skype занимал 80 и 443 порт. Решается она так: Skype>Инструменты>Настройки…>Дополнительно>Соединение. Снять галочку напротив «Для дополнительных входящих соединений следует использовать порты 80 и 443». Другой путь решения проблемы — менять порты в настройках Xampp и apache

2) Синтаксические ошибки в httpd.conf. При этом файлы error.log и access.log были пустые. Ошибки удалось увидеть толко благодаря прямому запуску apache через консоль: C:xamppapacheinhttpd.exe

Полный текст ошибки:

15:58:23 [Apache] Error: Apache shutdown unexpectedly.
15:58:23 [Apache] This may be due to a blocked port, missing dependencies,
15:58:23 [Apache] improper privileges, a crash, or a shutdown by another method.
15:58:23 [Apache] Press the Logs button to view error logs and check
15:58:23 [Apache] the Windows Event Viewer for more clues
15:58:23 [Apache] If you need more help, copy and post this
15:58:23 [Apache] entire log window on the forums

Добавить комментарий Отменить ответ

Рекомендую

Рекомендую всем хостинг 1gb.ru. Работает хорошо. Особенно радует техподдержка. Как-то раз они даже в мой PHP-код залезли и помогли решить проблему.

Кроме того, рекомендую всем хостинг Timeweb. Не очень мне нравится техподдержка (по сравнению с 1gb). А так же не рекомендую VDS на FreeBSD. Но, в остальном, всё работает замечательно. Замечательно подходит для больших проектов, особенно на Битриксе.

Разработка сайтов

Я окончил математико-механический факультет. Более 10 лет занимаюсь веб-программированием. На данный момент, в основном, пользуюсь CMS WordPress и 1С-Битрикс. По поводу создания или доработок сайтов на этих и других CMS пишите мне:

I have reinstalled XAMPP for some reason and MySQL is not working, giving the following error in the console:

Читайте также:  Lenovo g555 model 20045

When checking the "/xampp/mysql/data/mysql_error.log" file I get:

That is just a part of the log, the full one is a bit too big.

17 Answers 17

Quit your skype and try, if skype is opne

or

Go to your xampp/wamp installed, search for httpd.conf. Open that file using textpad/notepad, search for Listen or 80 , update listen port to 8081 and save the file. Restart xampp/wamp, start the servers.

or
follow below steps in skype

In my case, I did two things:

  1. moved xampp/mysql/backup files into xampp/mysql/data
  2. RUN XAMPP as Administrator

It worked for me 🙂

This worked for me,

  1. quit the XAMPP
  2. cut the All files in C:xamppmysqlackup
  3. paste and replace files in C:xamppmysqldata
  4. run as administrator the XAMPP
  • Close the xampp
  • Go to the folder where you installed it, if in (c:) may be something like C:xampp , access folder C:xamppmysqldata
  • Delete the file ibdata1
  • Starts XAMPP again.

There may be MySQL server installed previously in your computer try to uninstall that and start MySQL at the XAMPP This solved mine

The best solution for this problem is just open your mysql configuration directive file my.ini present inside the folder C:xamppmysqlin and change the information related to the ports, usually some programs occupy the port no. 3306 as a result of that it stops working, Now you follow two steps to make it working.

Thats it, restart you mysql service, it will work for sure.

I would simply try reinstalling XAMPP.

one reason I found ( and not mentioned in addition to other answers given in this site on the similar problem ) was by going to task manager in windows and stopping the mysqld which was running already and prevented mysql server from starting.

Читайте также:  Как загружать кисти в фотошоп

For anyone that searched and pressed on this link, i solved it by simply searching for mysql notifier and stop mysql from running there, Then run mysql in xampp again and it runs. why this works ? iam not expert, but i think it is easy : port was taken already by mysql notifier so had to stop it there and run it here.

I am new to XAMPP, but I find that a combination of these suggestions works best (At least on Windows 8.1 with the latest version of XAMPP. Note that the computer I tested this on, also had skype).

First logon to skype and navigate to "Tools

In my case : I have just replaced

It worked for me.

If Apache is running without any issue , and u find some blockage by system security settings , simply allow it instead of blocking or closing the dialog box. And change the port number for MySQL to 3607 as it was before 3606 . It worked for me .

if you inistalled mysql Independently you can stop mysql service if running no one of these answers are worked for me this work for me

Well first thing ,, I know its late so I dont know if anyone will upvote it but oh well its okay,, secondly, uninstalling xampp might not do you any good because the process using the port 3306 (Mysql’s default port) will still be running somewhere on your system. might be skype, but might not be skype.

so the best way would be to find out which process is using port 3306, and then terminate the process.

Читайте также:  Лучший провайдер цифрового телевидения в москве

so to find out which process is using port 3306, open command prompt, and type

you will get a screen like this.

Then look for the address with port number 3306 and find out the PID corresponding to that.

Then simply open a command prompt as administrator and type

replace 1234 with your respective PID. Then you can try starting mysql and it will work.

And now if you are lazy to do this step all over again when restarting the computer.

you can simply use the following batch script to terminate the process automatically and enjoy 🙂

a Jy d rZJK Qo b hK y Swzd e K NHS u aqcsN i qLTYj k BGf a vBckS B fLP o LoYxV o HUbM s bzxCS t f

Answer Wiki

First Method Shoud try :

Hey I just did this and it worked:

  1. exit Xampp server
  2. go to your C:xamppmysqldata directory
  3. delete the ibdata1 file
  4. restart xampp server

Also Use Second Method Shoud try :

  1. Go to mysql/data/
  2. Delete all random files (except the actual database folders)
  3. Restart Apache and MySQL.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *

Adblock detector