XAMPP设置 – MySQL不工作

我试图让XAMPP在Win7 / 64上testingWordpress主题。

我原来是Apache试图访问端口80的问题,但我被告知将configuration文件更改为端口81,我已经做了,现在Apache正在运行和localhost:81显示XAMPP控制面板罚款。

但是,现在MySQL根本不工作。 在我更改configuration文件之前,我想是的,但是Apache没有运行,所以我仍然无法访问本地主机。

Windows事件查看器中,我得到了MySQL上的这个错误报告:

Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 

在XAMPP的控制台,我目前正在这样做:

 17:07:36 [main] Initializing Control Panel 17:07:36 [main] Windows Version: Windows 7 Ultimate SP1 64-bit 17:07:36 [main] XAMPP Version: 1.8.1 17:07:36 [main] Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ] 17:07:36 [main] Running with Administrator rights - good! 17:07:36 [main] XAMPP Installation Directory: "c:\xampp\" 17:07:37 [main] Checking for prerequisites 17:07:37 [main] All prerequisites found 17:07:37 [main] Initializing Modules 17:07:37 [Apache] Problem detected! 17:07:37 [Apache] Port 80 in use by "system"! 17:07:37 [Apache] Apache WILL NOT start without the configured ports free! 17:07:37 [Apache] You need to uninstall/disable/reconfigure the blocking application 17:07:37 [Apache] or reconfigure Apache to listen on a different port 17:07:37 [Apache] XAMPP Apache is already running on port 443 17:07:37 [main] Starting Check-Timer 17:07:37 [main] Control Panel Ready 17:07:40 [mysql] Attempting to start MySQL app... 17:07:40 [mysql] Status change detected: running 17:07:41 [mysql] Status change detected: stopped 17:07:41 [mysql] Error: MySQL shutdown unexpectedly. 17:07:41 [mysql] This may be due to a blocked port, missing dependencies, 17:07:41 [mysql] improper privileges, a crash, or a shutdown by another method. 17:07:41 [mysql] Check the "/xampp/mysql/data/mysql_error.log" file 17:07:41 [mysql] and the Windows Event Viewer for more clues 17:07:47 [mysql] Attempting to start MySQL app... 

这里是MySQL的错误日志:

 130301 16:28:14 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:28:14 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:28:14 InnoDB: Completed initialization of buffer pool 130301 16:28:14 InnoDB: highest supported file format is Barracuda. 130301 16:28:15 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:28:15 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:28:43 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:28:43 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:28:43 InnoDB: Completed initialization of buffer pool 130301 16:28:43 InnoDB: highest supported file format is Barracuda. 130301 16:28:43 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:28:43 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:28:51 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:28:51 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:28:51 InnoDB: Completed initialization of buffer pool 130301 16:28:51 InnoDB: highest supported file format is Barracuda. 130301 16:28:52 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:28:52 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:30:07 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:30:07 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:30:07 InnoDB: Completed initialization of buffer pool 130301 16:30:07 InnoDB: highest supported file format is Barracuda. 130301 16:30:07 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:30:07 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:30:35 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:30:35 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:30:35 InnoDB: Completed initialization of buffer pool 130301 16:30:35 InnoDB: highest supported file format is Barracuda. 130301 16:30:35 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:30:35 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:30:43 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:30:43 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:30:43 InnoDB: Completed initialization of buffer pool 130301 16:30:43 InnoDB: highest supported file format is Barracuda. 130301 16:30:43 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:30:43 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:30:56 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:30:56 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:30:56 InnoDB: Completed initialization of buffer pool 130301 16:30:56 InnoDB: highest supported file format is Barracuda. 130301 16:30:57 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:30:57 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:30:59 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:30:59 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:30:59 InnoDB: Completed initialization of buffer pool 130301 16:30:59 InnoDB: highest supported file format is Barracuda. 130301 16:30:59 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:30:59 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:31:00 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:31:00 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:31:00 InnoDB: Completed initialization of buffer pool 130301 16:31:00 InnoDB: highest supported file format is Barracuda. 130301 16:31:01 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:31:01 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 16:31:02 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 16:31:02 InnoDB: Initializing buffer pool, size = 16.0M 130301 16:31:02 InnoDB: Completed initialization of buffer pool 130301 16:31:02 InnoDB: highest supported file format is Barracuda. 130301 16:31:02 InnoDB: 1.1.4 started; log sequence number 1595675 130301 16:31:02 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 17:00:46 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 17:00:46 InnoDB: Initializing buffer pool, size = 16.0M 130301 17:00:46 InnoDB: Completed initialization of buffer pool 130301 17:00:46 InnoDB: highest supported file format is Barracuda. 130301 17:00:47 InnoDB: 1.1.4 started; log sequence number 1595675 130301 17:00:47 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 17:07:40 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 17:07:40 InnoDB: Initializing buffer pool, size = 16.0M 130301 17:07:40 InnoDB: Completed initialization of buffer pool 130301 17:07:40 InnoDB: highest supported file format is Barracuda. 130301 17:07:40 InnoDB: 1.1.4 started; log sequence number 1595675 130301 17:07:40 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130301 17:07:47 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 130301 17:07:47 InnoDB: Initializing buffer pool, size = 16.0M 130301 17:07:47 InnoDB: Completed initialization of buffer pool 130301 17:07:47 InnoDB: highest supported file format is Barracuda. 130301 17:07:47 InnoDB: 1.1.4 started; log sequence number 1595675 130301 17:07:47 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 

有一个configuration文件,我需要改变以匹配的Apache文件? 没有什么明显的我可以看到。

提前谢谢了。

Solutions Collecting From Web of "XAMPP设置 – MySQL不工作"

通过卸载XAMPP完成解决问题,重新安装,然后将Apache使用的端口从80改为8080。

嘿,我只是这样做,它的工作:

  1. 退出Xampp服务器
  2. 转到您的C:\xampp\mysql\data目录
  3. 删除ibdata1文件
  4. 重新启动xampp服务器