HELP PLEASE: ERROR ON MYSQL!!!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 16. January 2016 13:28

Hi Forum,
Please i need direction on how to go about this error i'm experiencing. I'm a newbie on this. Thankfully, i solved the apache error.
What is left is this please. Thank you.

13:14:45 [mysql] Attempting to start MySQL service...
13:14:48 [mysql] Status change detected: running
13:14:56 [mysql] Status change detected: stopped
13:14:56 [mysql] Error: MySQL shutdown unexpectedly.
13:14:56 [mysql] This may be due to a blocked port, missing dependencies,
13:14:56 [mysql] improper privileges, a crash, or a shutdown by another method.
13:14:56 [mysql] Press the Logs button to view error logs and check
13:14:56 [mysql] the Windows Event Viewer for more clues
13:14:56 [mysql] If you need more help, copy and post this
13:14:56 [mysql] entire log window on the forums
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby eric99 » 16. January 2016 16:37

I'm having the same problem. The Windows Event Viewer is saying my database is corrupted and automatic repair doesn't fix it.

Have you checked your Windows Event Viewer for more information? Do a search on your windows version and event viewer to find out how to access it.
eric99
 
Posts: 8
Joined: 20. December 2014 16:46
Operating System: Windows 8.1

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 16. January 2016 22:03

Honestly, i'm lost. My window version is Microsoft 8.0. Don't even know how to check that please. I mean, the Windows Event Viewer,
Please direct me. Thanks
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby eric99 » 17. January 2016 16:09

I have no idea on how to do it on MS 8.0. Like I said, do a google search using: Windows 8 Microsoft event viewer
eric99
 
Posts: 8
Joined: 20. December 2014 16:46
Operating System: Windows 8.1

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 17. January 2016 17:02

Thanks bro
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

HELLO ALTREA!!!

Postby Seyi723 » 18. January 2016 09:19

Hello Altrea,
Please kindly help me.I'm begging you on this please as i have tried all known options to me.
I have fixed my apache and filezilla and they are now running fine. But mysql won't. Please help me.

This is the error i'm having please.Thank you.

09:16:35 [main] Initializing Control Panel
09:16:35 [main] Windows Version: Windows 8 64-bit
09:16:35 [main] XAMPP Version: 5.6.15
09:16:35 [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
09:16:35 [main] Running with Administrator rights - good!
09:16:35 [main] XAMPP Installation Directory: "c:\xampp\"
09:16:35 [main] Checking for prerequisites
09:16:38 [main] All prerequisites found
09:16:38 [main] Initializing Modules
09:16:38 [Apache] XAMPP Apache Service is already running on port 443
09:16:38 [filezilla] XAMPP FileZilla Service is already running on port 21
09:16:38 [filezilla] XAMPP FileZilla Service is already running on port 14147

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


This is the log as well please (mysql).

[i][b]2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-15 11:11:47 159c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 11:11:47 5532 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:11:47 5532 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:11:47 5532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:11:47 5532 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:11:47 5532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:11:47 5532 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:11:47 5532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:11:47 5532 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:11:48 5532 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:11:49 5532 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:11:49 5532 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:11:49 5532 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835037
2016-01-15 11:11:49 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:11:49 5532 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:11:50 5532 [Note] Server socket created on IP: '::'.
2016-01-15 11:11:50 5532 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:11:50 5532 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:11:50 5532 [ERROR] Aborting

2016-01-15 11:51:40 1a34 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 11:51:40 6708 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:51:40 6708 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:51:40 6708 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:51:40 6708 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:51:40 6708 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:51:40 6708 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:51:40 6708 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:51:40 6708 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:51:41 6708 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:52:17 6708 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:52:17 6708 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:52:17 6708 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835047
2016-01-15 11:52:18 7048 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:52:19 6708 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:52:21 6708 [Note] Server socket created on IP: '::'.
2016-01-15 11:52:21 6708 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:52:21 6708 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:52:21 6708 [ERROR] Aborting

2016-01-15 11:59:17 134c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 11:59:17 4940 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:59:17 4940 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:59:17 4940 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:59:17 4940 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:59:17 4940 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:59:17 4940 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:59:17 4940 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:59:17 4940 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:59:19 4940 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:59:55 4940 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:59:55 4940 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:59:55 4940 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835057
2016-01-15 11:59:57 7080 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:59:57 4940 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:59:57 4940 [Note] Server socket created on IP: '::'.
2016-01-15 11:59:57 4940 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:59:57 4940 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:59:57 4940 [ERROR] Aborting

2016-01-15 15:23:06 984 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:23:06 2436 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:23:06 2436 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:23:06 2436 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:23:06 2436 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:23:06 2436 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:23:06 2436 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:23:06 2436 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:23:06 2436 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:23:06 2436 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:23:07 2436 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:23:07 2436 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:23:07 2436 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835067
2016-01-15 15:23:07 3976 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:23:07 2436 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:23:07 2436 [Note] Server socket created on IP: '::'.
2016-01-15 15:23:07 2436 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:23:07 2436 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:23:07 2436 [ERROR] Aborting

2016-01-15 15:31:29 18a4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:31:29 6308 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:31:29 6308 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:31:29 6308 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:31:29 6308 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:31:29 6308 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:31:29 6308 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:31:29 6308 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:31:29 6308 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:31:30 6308 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:31:30 6308 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:31:30 6308 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:31:30 6308 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835077
2016-01-15 15:31:30 1172 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:31:30 6308 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:31:30 6308 [Note] Server socket created on IP: '::'.
2016-01-15 15:31:30 6308 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:31:30 6308 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:31:30 6308 [ERROR] Aborting

2016-01-15 15:31:35 fd0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:31:35 4048 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:31:35 4048 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:31:35 4048 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:31:35 4048 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:31:35 4048 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:31:35 4048 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:31:35 4048 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:31:35 4048 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:31:35 4048 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:31:36 4048 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:31:36 4048 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:31:36 4048 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835087
2016-01-15 15:31:36 6124 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:31:36 4048 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:31:36 4048 [Note] Server socket created on IP: '::'.
2016-01-15 15:31:36 4048 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:31:36 4048 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:31:36 4048 [ERROR] Aborting

2016-01-15 15:33:29 1b50 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:33:29 6992 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:33:29 6992 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:33:29 6992 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:33:29 6992 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:33:29 6992 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:33:29 6992 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:33:29 6992 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:33:29 6992 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:33:29 6992 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:33:30 6992 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:33:30 6992 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:33:30 6992 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835097
2016-01-15 15:33:30 1952 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:33:30 6992 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:33:30 6992 [Note] Server socket created on IP: '::'.
2016-01-15 15:33:30 6992 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:33:30 6992 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:33:30 6992 [ERROR] Aborting

2016-01-15 15:33:34 1344 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:33:34 4932 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:33:34 4932 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:33:34 4932 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:33:34 4932 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:33:34 4932 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:33:34 4932 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:33:34 4932 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:33:34 4932 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:33:35 4932 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:33:35 4932 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:33:35 4932 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:33:35 4932 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835107
2016-01-15 15:33:36 6392 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:33:36 4932 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:33:36 4932 [Note] Server socket created on IP: '::'.
2016-01-15 15:33:36 4932 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:33:36 4932 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:33:36 4932 [ERROR] Aborting

2016-01-15 15:54:17 c1c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:54:17 3100 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:54:17 3100 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:54:17 3100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:54:17 3100 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:54:17 3100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:54:17 3100 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:54:17 3100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:54:17 3100 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:54:17 3100 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:54:18 3100 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:54:18 3100 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:54:18 3100 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835117
2016-01-15 15:54:18 5972 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:54:18 3100 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:54:18 3100 [Note] Server socket created on IP: '::'.
2016-01-15 15:54:18 3100 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:54:18 3100 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:54:18 3100 [ERROR] Aborting

2016-01-15 15:56:28 bfc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:56:29 3068 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:56:29 3068 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:56:29 3068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:56:29 3068 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:56:29 3068 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:56:29 3068 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:56:29 3068 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:56:29 3068 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:56:29 3068 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:56:32 3068 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:56:32 3068 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:56:32 3068 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835127
2016-01-15 15:56:32 5800 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:56:32 3068 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:56:32 3068 [Note] Server socket created on IP: '::'.
2016-01-15 15:56:32 3068 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:56:32 3068 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:56:32 3068 [ERROR] Aborting

2016-01-15 15:57:38 f70 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:57:38 3952 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:57:38 3952 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:57:38 3952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:57:38 3952 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:57:38 3952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:57:38 3952 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:57:38 3952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:57:38 3952 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:57:38 3952 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:57:39 3952 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:57:39 3952 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:57:39 3952 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835137
2016-01-15 15:57:39 3952 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:57:39 3640 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:57:39 3952 [Note] Server socket created on IP: '::'.
2016-01-15 15:57:39 3952 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:57:39 3952 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:57:39 3952 [ERROR] Aborting

2016-01-15 15:58:20 20c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 15:58:20 524 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:58:20 524 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:58:20 524 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:58:20 524 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:58:20 524 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:58:20 524 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:58:20 524 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:58:20 524 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:58:20 524 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:58:21 524 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:58:21 524 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:58:21 524 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835147
2016-01-15 15:58:21 2896 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:58:21 524 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:58:21 524 [Note] Server socket created on IP: '::'.
2016-01-15 15:58:21 524 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:58:21 524 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:58:21 524 [ERROR] Aborting

2016-01-15 18:27:38 da8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 18:27:39 3496 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 18:27:39 3496 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 18:27:39 3496 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 18:27:39 3496 [Note] InnoDB: Memory barrier is not used
2016-01-15 18:27:39 3496 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 18:27:39 3496 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 18:27:39 3496 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 18:27:39 3496 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 18:27:39 3496 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 18:27:39 3496 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 18:27:39 3496 [Note] InnoDB: Waiting for purge to start
2016-01-15 18:27:39 3496 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835157
2016-01-15 18:27:40 1680 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 18:27:40 3496 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 18:27:40 3496 [Note] Server socket created on IP: '::'.
2016-01-15 18:27:40 3496 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 18:27:40 3496 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 18:27:40 3496 [ERROR] Aborting

2016-01-15 18:39:06 1668 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 18:39:06 5736 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 18:39:06 5736 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 18:39:06 5736 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 18:39:06 5736 [Note] InnoDB: Memory barrier is not used
2016-01-15 18:39:06 5736 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 18:39:06 5736 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 18:39:06 5736 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 18:39:06 5736 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 18:39:07 5736 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 18:39:07 5736 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 18:39:07 5736 [Note] InnoDB: Waiting for purge to start
2016-01-15 18:39:08 5736 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835167
2016-01-15 18:39:08 944 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 18:39:08 5736 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 18:39:08 5736 [Note] Server socket created on IP: '::'.
2016-01-15 18:39:08 5736 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 18:39:08 5736 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 18:39:08 5736 [ERROR] Aborting

2016-01-15 22:23:52 f58 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 22:23:52 3928 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 22:23:52 3928 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 22:23:52 3928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 22:23:52 3928 [Note] InnoDB: Memory barrier is not used
2016-01-15 22:23:52 3928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 22:23:52 3928 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 22:23:52 3928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 22:23:52 3928 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 22:23:53 3928 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 22:23:54 3928 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 22:23:54 3928 [Note] InnoDB: Waiting for purge to start
2016-01-15 22:23:54 3928 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835177
2016-01-15 22:23:54 7096 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 22:23:54 3928 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 22:23:55 3928 [Note] Server socket created on IP: '::'.
2016-01-15 22:23:55 3928 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 22:23:55 3928 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 22:23:55 3928 [ERROR] Aborting

2016-01-15 22:33:13 3d0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-15 22:33:13 976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 22:33:13 976 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 22:33:13 976 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 22:33:13 976 [Note] InnoDB: Memory barrier is not used
2016-01-15 22:33:13 976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 22:33:13 976 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 22:33:13 976 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 22:33:13 976 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 22:33:13 976 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 22:33:14 976 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 22:33:14 976 [Note] InnoDB: Waiting for purge to start
2016-01-15 22:33:14 976 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835187
2016-01-15 22:33:14 976 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 22:33:14 976 [Note] Server socket created on IP: '::'.
2016-01-15 22:33:14 5184 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 22:33:14 976 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 22:33:14 976 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 22:33:14 976 [ERROR] Aborting

2016-01-16 12:59:31 1c6c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 12:59:31 7276 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 12:59:31 7276 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 12:59:31 7276 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 12:59:31 7276 [Note] InnoDB: Memory barrier is not used
2016-01-16 12:59:31 7276 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 12:59:31 7276 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 12:59:31 7276 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 12:59:31 7276 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 12:59:31 7276 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 12:59:32 7276 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 12:59:32 7276 [Note] InnoDB: Waiting for purge to start
2016-01-16 12:59:32 7276 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835197
2016-01-16 12:59:32 6248 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 12:59:32 7276 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 12:59:32 7276 [Note] Server socket created on IP: '::'.
2016-01-16 12:59:32 7276 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 12:59:32 7276 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 12:59:32 7276 [ERROR] Aborting

2016-01-16 13:14:47 1d20 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 13:14:47 7456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 13:14:47 7456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 13:14:47 7456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 13:14:47 7456 [Note] InnoDB: Memory barrier is not used
2016-01-16 13:14:47 7456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 13:14:47 7456 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 13:14:47 7456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 13:14:47 7456 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 13:14:48 7456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 13:14:48 7456 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 13:14:48 7456 [Note] InnoDB: Waiting for purge to start
2016-01-16 13:14:49 7456 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835207
2016-01-16 13:14:49 7224 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 13:14:49 7456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 13:14:49 7456 [Note] Server socket created on IP: '::'.
2016-01-16 13:14:49 7456 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 13:14:49 7456 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 13:14:49 7456 [ERROR] Aborting

2016-01-16 14:52:27 14ec InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 14:52:27 5356 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 14:52:27 5356 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 14:52:27 5356 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 14:52:27 5356 [Note] InnoDB: Memory barrier is not used
2016-01-16 14:52:27 5356 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 14:52:27 5356 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 14:52:27 5356 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 14:52:27 5356 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 14:52:27 5356 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 14:52:27 5356 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 14:52:27 5356 [Note] InnoDB: Waiting for purge to start
2016-01-16 14:52:27 5356 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835217
2016-01-16 14:52:27 5476 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 14:52:27 5356 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 14:52:27 5356 [Note] Server socket created on IP: '::'.
2016-01-16 14:52:27 5356 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 14:52:27 5356 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 14:52:27 5356 [ERROR] Aborting

2016-01-16 15:00:19 1550 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 15:00:19 5456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:00:19 5456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:00:19 5456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:00:19 5456 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:00:19 5456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:00:19 5456 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:00:19 5456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:00:19 5456 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:00:19 5456 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:00:19 5456 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2016-01-16 15:00:20 5456 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile1
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:00:20 5456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:00:20 5456 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:00:20 5456 [ERROR] Aborting

2016-01-16 15:03:39 1d30 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 15:03:39 7472 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:03:39 7472 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:03:39 7472 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:03:39 7472 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:03:39 7472 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:03:39 7472 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:03:39 7472 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:03:39 7472 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:03:39 7472 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:03:39 7472 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:03:39 7472 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:03:40 7472 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:03:40 7472 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:03:40 7472 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:03:40 7472 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:03:40 7472 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:03:40 7472 [ERROR] Aborting

2016-01-16 15:04:55 1ffc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 15:04:55 8188 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:04:55 8188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:04:55 8188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:04:55 8188 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:04:55 8188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:04:55 8188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:04:55 8188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:04:55 8188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:04:55 8188 [Note] InnoDB: Restoring page 0 of tablespace 0
2016-01-16 15:04:55 8188 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2016-01-16 15:04:55 8188 [ERROR] InnoDB: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
2016-01-16 15:04:55 8188 [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!
2016-01-16 15:04:55 8188 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:04:55 8188 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:04:55 8188 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:04:55 8188 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:04:56 8188 [ERROR] Aborting

2016-01-16 15:07:53 1b2c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 15:07:54 6956 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:07:54 6956 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:07:54 6956 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:07:54 6956 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:07:54 6956 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:07:54 6956 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:07:54 6956 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:07:54 6956 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:07:54 6956 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:07:54 6956 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:07:54 6956 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:07:54 6956 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:07:54 6956 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:07:54 6956 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:07:54 6956 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:07:54 6956 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:07:54 6956 [ERROR] Aborting

2016-01-16 15:14:19 15a8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-16 15:14:19 5544 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:14:19 5544 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:14:19 5544 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:14:19 5544 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:14:19 5544 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:14:19 5544 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:14:19 5544 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:14:19 5544 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:14:19 5544 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:14:19 5544 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:14:19 5544 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:14:20 5544 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:14:20 5544 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:14:20 5544 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:14:20 5544 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:14:20 5544 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:14:20 5544 [ERROR] Aborting
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELLO ALTREA!!!

Postby Altrea » 19. January 2016 10:52

Seyi723 wrote:i have tried all known options to me.

I don't know what you have tried, but you are having a serious problem now.

At first MariaDB was starting successful:
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution


Then something happens, that the control panel was thinking MariaDB is not started, it tries to start the service but there is already a process occupying port 3306
2016-01-15 11:11:50 5532 [Note] Server socket created on IP: '::'.
2016-01-15 11:11:50 5532 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-15 11:11:50 5532 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:11:50 5532 [ERROR] Aborting

That would have been the chance to solve the issue if done correctly.

But then you have done something terrible, so that now MariaDB cannot access and create required files:
2016-01-16 15:00:19 5456 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:00:19 5456 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2016-01-16 15:00:20 5456 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile1
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:00:20 5456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:00:20 5456 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:00:20 5456 [ERROR] Aborting


I have no idea what you have done. So the best solution i can give you is to start over. Uninstall everything to do with XAMPP (inclusively stopping all services and processes, unregistering all services and deleting the whole xampp folder).
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 19. January 2016 14:32

Thank you so much for your time Altrea. I will be uninstalling everything and download a fresh new Xampp now.
I won't quit on Xampp even though alot of folks have advised me to use Wampp. Please, i need you to kindly stay with me on this sir.
Hopefully, i won't need to bother you again. However, if need be, i will get back to you again on the new Xampp as I'm downloading it now please. Thank you sir.
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Altrea » 19. January 2016 14:39

Please don't adjust any settings because you read it somewhere.
It is extremely difficult if not impossible to solve a problem while there are changes done in between.

We need to Analyse one problem after another.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 19. January 2016 15:35

Alright sir. Thank you. I won't touch anything this time around without your direction.
That was what i did with the last Xampp in a bid to get solutions
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 19. January 2016 16:09

Hello Altrea.
I just installed it now. Before the set-up was totally completed, i got this message please
USER ACCOUNT CONTROL: Some functions of Xampp are possibly restricted with UAC.
Please deactivate UAC Misconfig after the set up to avoid to install XAMPP to C:/program files (x86) (missing write permissions).
i went ahead to install it.
Also Altrea, please be aware sir that i now use Windows 8.1 pro.
Upon starting Xampp (With administrator right), this was the error i got please. Thanks

I have faith in you sir to help me love XAMPP!!!

3:58:09 PM [mysql] XAMPP MySQL is already running on port 3306
3:58:09 PM [main] Starting Check-Timer
3:58:09 PM [main] Control Panel Ready
3:58:19 PM [Apache] XAMPP Apache is already running on port 80
3:58:19 PM [Apache] XAMPP Apache is already running on port 443
3:58:19 PM [Apache] Attempting to start Apache service...
3:58:20 PM [Apache] Status change detected: running
3:58:21 PM [Apache] Status change detected: stopped
3:58:21 PM [Apache] Error: Apache shutdown unexpectedly.
3:58:21 PM [Apache] This may be due to a blocked port, missing dependencies,
3:58:21 PM [Apache] improper privileges, a crash, or a shutdown by another method.
3:58:21 PM [Apache] Press the Logs button to view error logs and check
3:58:21 PM [Apache] the Windows Event Viewer for more clues
3:58:21 PM [Apache] If you need more help, copy and post this
3:58:21 PM [Apache] entire log window on the forums
3:58:28 PM [mysql] XAMPP MySQL is already running on port 3306
3:58:28 PM [mysql] Attempting to start MySQL service...
3:58:29 PM [mysql] Status change detected: running
3:58:34 PM [mysql] Status change detected: stopped
3:58:34 PM [mysql] Error: MySQL shutdown unexpectedly.
3:58:34 PM [mysql] This may be due to a blocked port, missing dependencies,
3:58:34 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:58:34 PM [mysql] Press the Logs button to view error logs and check
3:58:34 PM [mysql] the Windows Event Viewer for more clues
3:58:34 PM [mysql] If you need more help, copy and post this
3:58:34 PM [mysql] entire log window on the forums
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby eric99 » 19. January 2016 16:26

It looks like you have both Apache and MySQL running.

Try rebooting your computer. If you get the message they are running again, click on the Config button in XAMPP. Uncheck the checkboxes that have Apache and MySQL start up upon the computers start.

Something is starting up Apache and MySQL
eric99
 
Posts: 8
Joined: 20. December 2014 16:46
Operating System: Windows 8.1

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Altrea » 19. January 2016 16:30

First thing: Unregister the Windows services for Apache and MySQL. This can easily be done by clicking in the green tick icons in your control panel.
After that please restart your control panel to get a full bunch of fresh log messages.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Seyi723 » 19. January 2016 17:19

YES!!!! YES!!!!
Mr Altrea and Mr. Eric, YOU ARE THE MEN!!! Oh, i feel like crying
Thank you so much sir. It is now working. Can you be my friends here??
Thanks alot you two!!!

This is the report sir. Well, i don't know the issues with Filezilla but i'm happy anyway. Way to go boss!!! Thanks again.

5:12:02 PM [main] Initializing Control Panel
5:12:02 PM [main] Windows Version: Windows 8.1 Pro 64-bit
5:12:02 PM [main] XAMPP Version: 5.6.15
5:12:02 PM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
5:12:02 PM [main] Running with Administrator rights - good!
5:12:02 PM [main] XAMPP Installation Directory: "c:\xampp\"
5:12:02 PM [main] Checking for prerequisites
5:12:04 PM [main] All prerequisites found
5:12:04 PM [main] Initializing Modules
5:12:04 PM [Apache] XAMPP Apache Service is already running on port 80
5:12:04 PM [Apache] XAMPP Apache Service is already running on port 443
5:12:04 PM [mysql] XAMPP MySQL Service is already running on port 3306
5:12:05 PM [main] Starting Check-Timer
5:12:05 PM [main] Control Panel Ready
5:12:44 PM [filezilla] Attempting to start FileZilla service...
5:17:14 PM [filezilla] Attempting to start FileZilla service...
5:17:30 PM [filezilla] Attempting to start FileZilla service...
Seyi723
 
Posts: 11
Joined: 15. January 2016 18:03
Operating System: Windows 8 Pro x64

Re: HELP PLEASE: ERROR ON MYSQL!!!

Postby Altrea » 19. January 2016 20:48

Okay, still not okay. The services are still there and started.

So we try a different way to get rid of this services.

Please open your Windows command line (cmd) with enhanced administration rights (rightclick -> run as Administrator).

After that enter the following command
Code: Select all
sc stop Apache2.4

The output of that should be something like
SERVICE_NAME: Apache2.4
TYPE : 10 WIN32_OWN_PROCESS
STATE : 3 STOP_PENDING
(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x2
WAIT_HINT : 0x7530


Then enter the next command
Code: Select all
sc delete Apache2.4


should result in something like
[SC] DeleteService SUCCESS


The same with mysql
Code: Select all
sc stop mysql

Code: Select all
sc delete mysql


After that again restart your control panel (run as Administrator)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 99 guests