MySQL service is not starting
Posted by: gratiela (46.251.126.---)
Date: February 24, 2017 11:16AM

The MySQL service is not starting today (did work fine few days ago when I last used it).

Some specifics about my installation:

1. The OS is Windows 10 (64 bit)
2. WampServer Version 3.0.0 64bit
3. Apache version 2.4.17
4. PHP version 5.6.16
5. MySQL version 5.7.9
6. WampServer icon is yellow
and the MySQL log says:

2017-02-24T09:50:49.487055Z 0 [ERROR] InnoDB: Only one log file found.
2017-02-24T09:50:49.489062Z 0 [ERROR] InnoDB: Plugin initialization aborted with error not found
2017-02-24T09:50:49.691171Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-02-24T09:50:49.692677Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-02-24T09:50:49.694177Z 0 [ERROR] Failed to initialize plugins.
2017-02-24T09:50:49.695177Z 0 [ERROR] Aborting

Can anyone help me, please? Thanks



Edited 1 time(s). Last edit at 02/24/2017 11:42AM by gratiela.

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: gratiela (46.251.126.---)
Date: February 25, 2017 09:08AM

Nobody has any idea? I guess the only solution I see is to uninstall Wamp and start over.

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: RiggsFolly (Moderator)
Date: February 25, 2017 09:16AM

Did you install WAMPServer using the "Run as Administratoe" as suggested?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: gratiela (46.251.126.---)
Date: February 25, 2017 01:51PM

Yes, and Wamp has been working fine for about 1 year. So, this is not a new installation.
The only thing that I've done from the time Wamp was working to the time the problem appeared is scanning my system for viruses (I used Avast). So, I'm thinking, is possible the antivirus deleted something Wamp was using?

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: Otomatic (Moderator)
Date: February 25, 2017 05:32PM

Hi,

> (I used Avast).
Uninstall totally this shit that does much more harm than good.
And the total uninstallation is not won in advance; This spider leaves scraps of cloth everywhere and replaces some Windows files with its own files but does not reset them to uninstall.

Are there any errors in the Windows Event Viewer relative to MySQL?
(Using the Event Viewer: [www.sevenforums.com])

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.11/7.0.25/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.11/7.0.25/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: gratiela (46.251.126.---)
Date: February 26, 2017 11:59AM

Thanks for the reply! I found a solution before seeing your post (probably not the most inteligent, but here it is):

Since I suspected Avast as the responsible for the problem, I went to it's "virus chest" and searched for any files originated from wamp. And I found just one - ib_logfile1 (original path being C:\wamp64\bin\mysql\mysql5.7.9\data). So I restored it. After that everything went back to normal - the wamp icon turned green, and my projects are working fine again. Out of curiosity I scanned the file again and surprise, it turn out clean this time. (stupid antivirus)

Could you suggest a better antivirus, one that at least doesn't mess up my files? Thanks

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: Otomatic (Moderator)
Date: February 26, 2017 03:39PM

Hi,

> Could you suggest a better antivirus,
Not Avast who fuck shit everywhere, not Kaspersky, real gas factory where it takes hours to find where the parameter to be changed.
Eventually Avira. The others I do not know.
Nevertheless, associated with Windows Defender which does very well its work, the best anti-virus is the interface between the chair and the keyboard that does not click on everything that moves, and that thinks its actions before open the last video of death that kills.

To uninstall Avast : [www.avast.com]

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.11/7.0.25/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.11/7.0.25/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



Edited 1 time(s). Last edit at 02/26/2017 05:34PM by Otomatic.

Options: ReplyQuote
Re: MySQL service is not starting
Posted by: gratiela (46.251.126.---)
Date: February 28, 2017 01:06PM

Thanks! I'll be checking Avira.

Options: ReplyQuote


Sorry, only registered users may post in this forum.