MySQL Error #2002 and won't start
Posted by: ardiartani (---.nycmny.fios.verizon.net)
Date: May 01, 2015 05:25PM

Windows 7 32-bit
WAMP Server 2.5 32-bit
Apache 2.4.9
PHP 5.5.12
MySQL 5.6.17
Wamp Color icon : ORANGE


When i try to access localhost/phpmyadmin it show this error:

MySQL said: Documentation

#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: RiggsFolly (---.as43234.net)
Date: May 02, 2015 03:22PM

I would say that your MYSQL server is not running as the wampmanager icon is Orange.

You seem to have readthis post [forum.wampserver.com] so what are the errors in the System Event Log from MySQL?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: ardiartani (---.nycmny.fios.verizon.net)
Date: May 02, 2015 04:11PM

Host file is :
127.0.0.1 localhost
#::1 localhost

127.0.0.1 localhost
127.0.0.1 thecelebrityfacts.com

8. i can access localhost
9. when i enter the url it show the error #2002
10. i dont use any antivirus
11. F:/wamp

ERROR LOG


2015-04-30 09:40:21 2968 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 09:40:21 2968 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 09:40:21 2968 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 09:40:21 2968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 09:40:21 2968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 09:40:21 2968 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 09:40:21 2968 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 09:40:21 2968 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 09:40:22 2968 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 09:40:22 bb8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 09:40:22 2968 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 09:57:44 3668 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 09:57:44 3668 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 09:57:44 3668 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 09:57:44 3668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 09:57:44 3668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 09:57:44 3668 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 09:57:44 3668 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 09:57:44 3668 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 09:57:44 3668 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 09:57:44 9ec InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 09:57:44 3668 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 09:59:23 1984 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 09:59:23 1984 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 09:59:23 1984 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 09:59:23 1984 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 09:59:23 1984 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 09:59:23 1984 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 09:59:23 1984 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 09:59:23 1984 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 09:59:23 1984 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 09:59:23 79c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 09:59:23 1984 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:01:53 3584 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:01:53 3584 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:01:53 3584 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:01:53 3584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:01:53 3584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:01:53 3584 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:01:53 3584 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:01:53 3584 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:01:53 3584 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:01:53 830 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:01:53 3584 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:02:23 3628 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:02:23 3628 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:02:23 3628 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:02:23 3628 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:02:23 3628 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:02:23 3628 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:02:24 3628 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:02:24 3628 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:02:24 3628 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:02:24 3b0 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:02:24 3628 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:30:09 964 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:30:09 964 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:30:09 964 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:30:09 964 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:30:09 964 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:30:09 964 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:30:09 964 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:30:09 964 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:30:09 964 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:30:09 e64 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:30:09 964 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:32:39 3540 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:32:39 3540 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:32:39 3540 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:32:39 3540 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:32:39 3540 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:32:39 3540 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:32:39 3540 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:32:39 3540 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:32:39 3540 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:32:39 af4 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:32:39 3540 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:34:19 3672 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:34:19 3672 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:34:19 3672 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:34:19 3672 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:34:19 3672 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:34:19 3672 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:34:19 3672 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:34:19 3672 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:34:19 3672 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:34:19 a2c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:34:19 3672 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-04-30 10:36:20 2172 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 10:36:20 2172 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 10:36:20 2172 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 10:36:20 2172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-30 10:36:20 2172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 10:36:20 2172 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-30 10:36:20 2172 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 10:36:20 2172 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 10:36:21 2172 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-30 10:36:21 dec InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-04-30 10:36:21 2172 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 07:26:47 2236 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 07:26:47 2236 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 07:26:47 2236 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 07:26:47 2236 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 07:26:47 2236 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 07:26:47 2236 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 07:26:47 2236 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 07:26:47 2236 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 07:26:48 2236 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 07:26:48 5d8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 07:26:48 2236 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:21:27 3928 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:21:27 3928 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:21:27 3928 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:21:27 3928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:21:27 3928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:21:27 3928 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:21:27 3928 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:21:27 3928 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:21:27 3928 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:21:27 c00 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:21:27 3928 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:26:48 3244 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:26:48 3244 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:26:48 3244 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:26:48 3244 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:26:48 3244 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:26:48 3244 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:26:48 3244 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:26:48 3244 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:26:49 3244 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:26:49 fa4 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:26:49 3244 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:26:54 4024 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:26:54 4024 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:26:54 4024 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:26:54 4024 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:26:54 4024 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:26:54 4024 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:26:54 4024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:26:54 4024 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:26:54 4024 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:26:54 dec InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:26:54 4024 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:52:09 3612 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:52:09 3612 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:52:09 3612 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:52:09 3612 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:52:09 3612 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:52:09 3612 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:52:10 3612 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:52:10 3612 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:52:10 3612 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:52:10 fa8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:52:10 3612 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:52:16 2584 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:52:16 2584 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:52:16 2584 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:52:16 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:52:16 2584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:52:16 2584 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:52:16 2584 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:52:16 2584 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:52:16 2584 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:52:16 9b4 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:52:16 2584 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:54:58 3192 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:54:58 3192 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:54:58 3192 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:54:58 3192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:54:58 3192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:54:58 3192 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:54:58 3192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:54:58 3192 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:54:58 3192 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:54:58 d38 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:54:58 3192 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:55:04 1164 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:55:04 1164 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:55:04 1164 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:55:04 1164 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:55:04 1164 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:55:04 1164 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:55:04 1164 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:55:04 1164 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:55:04 1164 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:55:04 13c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:55:04 1164 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 10:55:15 1800 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 10:55:15 1800 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 10:55:15 1800 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 10:55:15 1800 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 10:55:15 1800 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 10:55:15 1800 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 10:55:15 1800 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 10:55:15 1800 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 10:55:15 1800 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 10:55:15 4c0 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 10:55:15 1800 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:00:23 1692 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:00:23 1692 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:00:23 1692 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:00:23 1692 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:00:23 1692 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:00:23 1692 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:00:23 1692 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:00:23 1692 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:00:23 1692 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:00:23 508 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:00:23 1692 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:00:30 1732 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:00:30 1732 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:00:30 1732 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:00:30 1732 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:00:30 1732 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:00:30 1732 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:00:30 1732 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:00:30 1732 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:00:30 1732 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:00:30 c2c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:00:30 1732 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:03:10 1428 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:03:10 1428 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:03:10 1428 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:03:10 1428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:03:10 1428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:03:10 1428 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:03:10 1428 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:03:10 1428 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:03:10 1428 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:03:10 d44 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:03:10 1428 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:03:20 1072 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:03:20 1072 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:03:20 1072 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:03:20 1072 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:03:20 1072 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:03:20 1072 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:03:20 1072 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:03:20 1072 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:03:20 1072 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:03:20 338 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:03:20 1072 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:06:19 1004 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:06:19 1004 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:06:19 1004 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:06:19 1004 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:06:19 1004 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:06:19 1004 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:06:19 1004 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:06:19 1004 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:06:19 1004 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:06:19 ecc InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:06:19 1004 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:10:37 3052 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:10:37 3052 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:10:37 3052 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:10:37 3052 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:10:37 3052 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:10:37 3052 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:10:37 3052 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:10:37 3052 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:10:37 3052 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:10:37 94 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:10:37 3052 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:10:50 3972 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:10:50 3972 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:10:50 3972 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:10:50 3972 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:10:50 3972 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:10:50 3972 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:10:50 3972 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:10:50 3972 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:10:50 3972 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:10:50 6f8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:10:50 3972 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:13:00 2204 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:13:00 2204 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:13:00 2204 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:13:00 2204 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:13:00 2204 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:13:00 2204 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:13:00 2204 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:13:00 2204 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:13:00 2204 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:13:00 ddc InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:13:00 2204 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:13:05 3528 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:13:05 3528 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:13:05 3528 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:13:05 3528 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:13:05 3528 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:13:05 3528 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:13:05 3528 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:13:05 3528 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:13:06 3528 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:13:06 bc0 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:13:06 3528 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:27:47 2492 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:27:47 2492 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:27:47 2492 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:27:47 2492 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:27:47 2492 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:27:47 2492 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:27:47 2492 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:27:47 2492 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:27:47 2492 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:27:47 824 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:27:47 2492 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-01 11:27:54 2248 [Note] Plugin 'FEDERATED' is disabled.
2015-05-01 11:27:54 2248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-01 11:27:54 2248 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-01 11:27:54 2248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-01 11:27:54 2248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-01 11:27:54 2248 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-01 11:27:54 2248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-01 11:27:54 2248 [Note] InnoDB: Completed initialization of buffer pool
2015-05-01 11:27:55 2248 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-01 11:27:55 dac InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-01 11:27:55 2248 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2015-05-02 10:06:13 512 [Note] Plugin 'FEDERATED' is disabled.
2015-05-02 10:06:13 512 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-02 10:06:13 512 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-02 10:06:13 512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-02 10:06:13 512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-02 10:06:13 512 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-02 10:06:13 512 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-02 10:06:13 512 [Note] InnoDB: Completed initialization of buffer pool
2015-05-02 10:06:13 512 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-02 10:06:13 2a0 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-05-02 10:06:13 512 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: RiggsFolly (---.as43234.net)
Date: May 02, 2015 09:32PM

So you didnt bother to mention these errors in your first question. HELPFUL


One of those error sets would have been enough, they are afterall just the same error reapeated Again and Again and Again and ..........


I did a quick google and found this [bugs.mysql.com] where is states that adding this line to your my.ini may help. Add this in the [wampmysqld] section of my.ini

[wampmysqld]
innodb_flush_method=normal


I would be interested to know if this works.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: ardiartani (---.nycmny.fios.verizon.net)
Date: May 02, 2015 11:34PM

it worked thank you so much smiling smiley

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: ardiartani (---.nycmny.fios.verizon.net)
Date: May 03, 2015 12:27AM

i have one more error when i try to install a php script i test the connection it says that is was connected when i click install it shows a error ??

Error Log

InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.

Options: ReplyQuote
Re: MySQL Error #2002 and won't start
Posted by: RiggsFolly (---.as43234.net)
Date: May 03, 2015 01:26AM

Have you set innodb_force_recovery in your my.ini? Sounds like you have, if so remove it

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.