Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

configuration of mysql server installation failed OR can't start the service [closed]

I'm installing mysql server 5.6 but when it comes to installing configuration it sucks on attempting to start service and when I cancel and try to start from Services it says: Error 1067: The program terminated unexpectedly.

and here's my .err:

2014-03-17 20:42:10 1372 [Note] Plugin 'FEDERATED' is disabled.
2014-03-17 20:42:10 fe0 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.
2014-03-17 20:42:10 1372 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-17 20:42:10 1372 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-17 20:42:10 1372 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-17 20:42:10 1372 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-17 20:42:10 1372 [Note] InnoDB: Initializing buffer pool, size = 39.0M
2014-03-17 20:42:10 1372 [Note] InnoDB: Completed initialization of buffer pool
2014-03-17 20:42:10 1372 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-17 20:42:10 fe0  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
2014-03-17 20:42:10 1372 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS     error 187. Cannot continue operation
like image 702
Bayar Avatar asked Mar 17 '14 18:03

Bayar


People also ask

Why MySQL service is not starting?

Even with correct ownership, MySQL might fail to start up if there is other security software running on your system that manages application access to various parts of the file system. In this case, reconfigure that software to enable mysqld to access the directories it uses during normal operation.

How do I reconfigure MySQL installer?

To restart the server configuration, open MySQL Installer from the Start menu and click Reconfigure next to the appropriate server in the dashboard. Product configuration. This step applies to MySQL Server, MySQL Router, and samples only.


1 Answers

solution:

add this line to config file (my.ini in programData...)

innodb_flush_method=normal

http://bugs.mysql.com/bug.php?id=28913

like image 118
Bayar Avatar answered Oct 12 '22 22:10

Bayar