安装Xammp时启动MySql服务时出错

Question

我已经安装了Apache，并在端口80上启动了Apache服务。但是在启动Apache服务后，MySql服务没有启动，并给出了这个错误：

11:53:47 AM  [mysql]    Attempting to start MySQL service...
11:53:47 AM  [mysql]    Status change detected: running
11:53:53 AM  [mysql]    Status change detected: stopped
11:53:53 AM  [mysql]    Error: MySQL shutdown unexpectedly.
11:53:53 AM  [mysql]    This may be due to a blocked port, missing dependencies, 
11:53:53 AM  [mysql]    improper privileges, a crash, or a shutdown by another method.
11:53:53 AM  [mysql]    Press the Logs button to view error logs and check
11:53:53 AM  [mysql]    the Windows Event Viewer for more clues
11:53:53 AM  [mysql]    If you need more help, copy and post this
11:53:53 AM  [mysql]    entire log window on the forums

因此，我在日志文件中复制了错误：

2014-10-06 19:42:58 6820 [ERROR] Can't start server: Bind on TCP/IP port: No such file or      directory
2014-10-06 19:42:58 6820 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2014-10-06 19:42:58 6820 [ERROR] Aborting

2014-10-06 19:49:17 3392 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-10-06 19:49:17 3392 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-10-06 19:49:17 3392 [ERROR] Aborting
2014-10-06 19:55:59 6260 [ERROR] InnoDB: Cannot create D:\xampp1\mysql\data\ib_logfile1
2014-10-06 19:55:59 6260 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-06 19:55:59 6260 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-06 19:55:59 6260 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-06 19:55:59 6260 [ERROR] Aborting
2014-10-06 19:57:45 7920 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp1\mysql\data\ibdata1
2014-10-06 19:57:45 7920 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-10-06 19:57:45 7920 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-06 19:57:45 7920 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-06 19:57:45 7920 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-06 19:57:45 7920 [ERROR] Aborting
2014-10-06 19:57:58 6240 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp1\mysql\data\ibdata1
2014-10-06 19:57:58 6240 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-10-06 19:57:58 6240 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-06 19:57:58 6240 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-06 19:57:58 6240 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-06 19:57:58 6240 [ERROR] Aborting
2014-10-06 21:10:22 5612 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp1\mysql\data\ibdata1
2014-10-06 21:10:22 5612 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-10-06 21:10:22 5612 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-06 21:10:22 5612 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-06 21:10:22 5612 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-06 21:10:22 5612 [ERROR] Aborting

..

请帮我安装这个web服务器。谢谢

Answer 1

停止其他mysql服务

或

打开C:\xampp\mysql\bin\my.ini，然后更改端口

...
[mysqld]
port= 3306    <----- change to another port number
...

Answer 2

这是因为该特定端口当前正由另一个服务使用。

http://www.sitepoint.com/unblock-port-80-on-windows-run-apache/

https://sites.google.com/site/anashkb/port-80-in-use

一个类似的问题也被问到，你可以查看它

Apache server Installation failed(Port 80 or 443 already in use)

Answer 3

Apache is使用端口80，且该端口已在您系统中使用(可能您正在使用skype)。为了启动Apache，请释放系统中的端口80。(从skype或其他使用端口80的程序注销)。再试一次。