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文件？ 没有什么明显的我可以看到。

提前谢谢了。