[Win 10] MySql dont want to start. [solved]

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

[Win 10] MySql dont want to start. [solved]

Postby Grzybon » 07. December 2015 18:10

As topic says. Apache is starting without problems but mysql dont want to start at all. Ive tried to reinstal but didnt help.

Here is error log
2015-12-07 18:02:04 1e1c 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-12-07 18:02:04 7708 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-12-07 18:02:04 7708 [Note] InnoDB: The InnoDB memory heap is disabled
2015-12-07 18:02:04 7708 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-12-07 18:02:04 7708 [Note] InnoDB: Memory barrier is not used
2015-12-07 18:02:04 7708 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-07 18:02:04 7708 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-07 18:02:04 7708 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-12-07 18:02:04 7708 [Note] InnoDB: Completed initialization of buffer pool
2015-12-07 18:02:04 7708 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-07 18:02:04 1e1c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
InnoDB: Operation read to file os\os0file.cc and at line 3134
2015-12-07 18:02:04 7708 [ERROR] InnoDB: File (unknown): 'read' returned OS error 287. Cannot continue operation


Xampp version
xampp-win32-5.6.14-4-VC11-installer.exe
Win 10 Home 64
XAMPP installation path
D:\xampp
Grzybon
 
Posts: 2
Joined: 07. December 2015 18:06
Operating System: Windows 10

Re: [Win 10] MySql dont want to start. [solved]

Postby Grzybon » 07. December 2015 19:34

Open MySQL config file by “Config” —> “my.ini”.
Insert
innodb_flush_method=normal

between
innodb_lock_wait_timeout = 50

and
## UTF 8 Settings

Start MySQL again in xampp.
Grzybon
 
Posts: 2
Joined: 07. December 2015 18:06
Operating System: Windows 10

Re: [Win 10] MySql dont want to start. [solved]

Postby vsg24 » 24. June 2017 23:10

I was having the same problem when I installed XAMPP on a MacBook Pro 2016 laptop that was running Windows 10 Pro in Bootcamp. The instructions provided by @Grzybon worked flawlessly.
vsg24
 
Posts: 1
Joined: 24. June 2017 23:07
XAMPP version: 3.2.2
Operating System: Windows 10 Pro

Re: [Win 10] MySql dont want to start. [solved]

Postby FrederikLive » 07. March 2018 08:06

Perfect solution!
FrederikLive
 
Posts: 1
Joined: 24. April 2017 04:46
XAMPP version: 5.3
Operating System: Win 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 119 guests