New Installation of SQL (unable to start)

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

New Installation of SQL (unable to start)

Postby Dj10234 » 13. June 2017 15:06

Hello Everyone!

I recently downloaded XAMPP 3.2.2 and I'm unable to start mySQL

- Problem detected! Port 3306 in use by "unable to open process"!

1. I've attempted to change ALL the ports in the my.ini file to 3360 and it does not fix the issue.

2. I opened CMD - netstat -a -b and windows cannot tell me the file that is using port 3306

https://gyazo.com/233b7e60b4d8a245e56cc2dd9b2bc37f

Any ideas on how to resolve this issue? Thank you for your time =)



Log for Reference:

2017-06-13 09:03:34 20d4c 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.
2017-06-13 9:03:34 134476 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-06-13 9:03:34 134476 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-13 9:03:34 134476 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-13 9:03:34 134476 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-13 9:03:34 134476 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-13 9:03:34 134476 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-13 9:03:34 134476 [Note] InnoDB: Using generic crc32 instructions
2017-06-13 9:03:34 134476 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-13 9:03:34 134476 [Note] InnoDB: Completed initialization of buffer pool
2017-06-13 9:03:34 134476 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2017-06-13 9:03:34 134476 [ERROR] InnoDB: The system tablespace must be writable!
2017-06-13 9:03:34 134476 [ERROR] Plugin 'InnoDB' init function returned error.
2017-06-13 9:03:34 134476 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-06-13 9:03:34 134476 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-13 9:03:34 134476 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-06-13 9:03:34 134476 [ERROR] Aborting

2017-06-13 09:03:46 1b534 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.
2017-06-13 9:03:46 111924 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-06-13 9:03:46 111924 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-13 9:03:46 111924 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-13 9:03:46 111924 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-13 9:03:46 111924 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-06-13 9:03:46 111924 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-13 9:03:46 111924 [Note] InnoDB: Using generic crc32 instructions
2017-06-13 9:03:46 111924 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-13 9:03:46 111924 [Note] InnoDB: Completed initialization of buffer pool
2017-06-13 9:03:46 111924 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2017-06-13 9:03:46 111924 [ERROR] InnoDB: The system tablespace must be writable!
2017-06-13 9:03:46 111924 [ERROR] Plugin 'InnoDB' init function returned error.
2017-06-13 9:03:46 111924 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-06-13 9:03:46 111924 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-13 9:03:46 111924 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-06-13 9:03:46 111924 [ERROR] Aborting
Dj10234
 
Posts: 1
Joined: 13. June 2017 14:45
XAMPP version: 3.2.2
Operating System: windows 7 pro 64 bit

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 88 guests