MySQL Service not starting on Windows 10 ver. 1703, build 15063.540
Posted by: mart225 (95.147.100.---)
Date: September 05, 2017 04:11PM

Hi everyone, I'm new here and as such I have a small problem with the built in MySQL in the latest version of WampServer 3.0.6 the 64bit version.

I get a strange error that prevents me from starting the MySQL service. When opening the log file I get:

<----- STARTING CITATION OF THE MYSQL LOG FILE----->
wampmysqld64: Table 'mysql.plugin' doesn't exist
2017-09-05T13:42:51.527456Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-05T13:42:51.529491Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-05T13:42:51.530493Z 0 [Warning] Failed to open optimizer cost constant tables

2017-09-05T13:42:51.530493Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-09-05T13:42:51.530493Z 0 [ERROR] Aborting
<-----END OF LOG FILE----->

I have searched here and there for solutions and I have tried to delete the log files located in "wamp/bin/MySQL/mysql5.7.14/data/" - no success, the service builds them again and outputs the same error.

I have also installed all the needed Microsoft Visual C/C++ Redistributable Packages from 2008 (VC9) to 2017 (VC15) both 32 and 64 bit.

I have fully stopped the Internet Information Services of Microsoft including the WWW Services in the whole OS.

I don't have Skype installed at all.

If I try to get to MySQL console I get an error after I enter the password for the console, which by the way I have never set up.

I haven't modified anything I just installed it on my new computer freshly from the website, that's why I am confused about the console password.

The WampServer icon is orange.

Windows 10 Pro - ver. 1703, build 15063.540, 64 bit.
Apache version - 2.4.23
PHP version - 5.6.25
MySQL version - 5.7.14

Any other ideas?

Thank you for you understanding.

Wish you a great day/night. smiling smiley



Edited 2 time(s). Last edit at 09/05/2017 04:18PM by mart225.

Options: ReplyQuote
Re: MySQL Service not starting on Windows 10 ver. 1703, build 15063.540
Posted by: Otomatic (Moderator)
Date: September 05, 2017 04:21PM

Hi,

> I have also installed all the needed Microsoft Visual C/C++ Redistributable Packages
> from 2008 (VC9) to 2017 (VC15) both 32 and 64 bit.
- Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
And you will find all the packages on [wampserver.aviatechno.net] in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.

Then apply all points of TROUBLESHOOTING TIPS

But, as stated in the message displayed when installing Wampserver, all this should have been done BEFORE the actual installation.

> in the latest version of WampServer 3.0.6
3.1.0 see WAMPserver 3 - All you need to know

------------------------------------------------------------------------------------------------------------
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 not starting on Windows 10 ver. 1703, build 15063.540
Posted by: mart225 (95.147.100.---)
Date: September 05, 2017 05:33PM

Hi, thanks for your fast response.
I have ran the "check_vcredist.exe" and it outputted "All VC++ packages needed to Wampserver are installed correctly". And then listed all the X86 packages and also the X64 packages I have previously installed.
I again decided to check and I fully uninstalled WampServer, restarted my computer and installed it again freshly, to the "C://" directory. After the installation the WampServer icon is still orange, so I followed all the troubleshooting instructions that you gave me, but nothing, so I decided to update to the latest version of WampServer 3.1.0, and so I did but the issue persist, this time the MySQL Log outputted this:

<-----START OF LOG CITATION----->
2017-09-05T15:28:34.051588Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to [dev.mysql.com] for how to resolve the issue.
2017-09-05T15:28:34.051588Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2017-09-05T15:28:34.051588Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-09-05T15:28:34.379738Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-05T15:28:34.379738Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-05T15:28:34.379738Z 0 [ERROR] Failed to initialize plugins.
2017-09-05T15:28:34.379738Z 0 [ERROR] Aborting
<-----END OF LOG----->
Basically the same error I think.
Should I try anything else?

Options: ReplyQuote
Re: MySQL Service not starting on Windows 10 ver. 1703, build 15063.540
Posted by: Otomatic (Moderator)
Date: September 05, 2017 06:01PM

Hi,

Exit Wampserver.

With Files explorer, delete the totality of files and folders into wamp\bin\mysql\mysql5.7.14\data\ and the folder data itself.

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) on the folder wamp\bin\mysql\mysql5.7.19\bin\
In this command windows type :
mysqld.exe --initialize-insecure

This will recreate the data folder

------------------------------------------------------------------------------------------------------------
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 not starting on Windows 10 ver. 1703, build 15063.540
Posted by: mart225 (95.147.100.---)
Date: September 05, 2017 06:16PM

Thank you, I exited WampServer then navigated to the data folder, deleted all the files in it, and then deleted the whole "data" folder, then ran CMD as Admin and cd to the bin folder in MySQL and ran
the command then the folder reappeared and I again ran WampServer but the issue still persist, the log file still outputs the same error "Failed initialize plugins."

Is it possible not to be working because I'm running Windows 10 on MacBook Pro 2017, via BootCamp?
But if it is it wouldn't make sense because I have successfully installed WampServer on my older MacBook again running Windows 10 Pro via BootCamp.

Hope the issue is fixable.

Options: ReplyQuote
Re: MySQL Service not starting on Windows 10 ver. 1703, build 15063.540
Posted by: Otomatic (Moderator)
Date: September 05, 2017 06:33PM

Hi,

> Hope the issue is fixable.
I know nothing about it.
I do not have a MacBook and none of my acquaintance has one.
Also, I know Windows 7 or 10 and its tools and I know where to look when there is a problem, but I do not know anything about MacBook and BootCamp.

Is the disk NTFS?
Does BootCamp support symbolic links?
Are you the owner of the installation folder and subfolders and do you have full control over them? "owner" and "full control" are terms of the Windows properties of files and folders.
I am afraid I can not help you any further.

> But if it is it wouldn't make sense
But it makes sense!
It's not the same hardware, not the same operating system, not the same parameters.

------------------------------------------------------------------------------------------------------------
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 not starting on Windows 10 ver. 1703, build 15063.540
Posted by: mart225 (95.147.100.---)
Date: September 05, 2017 06:46PM

Yes the partition is formatted with the New Technology File System (NTFS). And yes BootCamp supports symbolic links, yes I am the owner of the system and the only account there is mine, set as Administrator.
Thank you for the time spent on answering my questions, I'm gonna continue to troubleshoot, if you have any other ideas it would be great.
Wish you the best! smiling smiley

Options: ReplyQuote
Re: MySQL Service not starting on Windows 10 ver. 1703, build 15063.540
Posted by: Otomatic (Moderator)
Date: September 05, 2017 07:11PM

Hi,

Just a "trick" by the way:
- Wampserver Installer 3.1.0 32 bit = about 397 MB
After installation wamp folder is about 4.2 GB

- Wampserver Installer 3.1.0 64 bit = about 432 MB
After installation wamp64 folder is about 4.5 GB

Have you booked enough space on the drive for Wampserver?

------------------------------------------------------------------------------------------------------------
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 not starting on Windows 10 ver. 1703, build 15063.540
Posted by: mart225 (95.147.100.---)
Date: September 05, 2017 08:02PM

Hi,
Yes my BootCamp SSD has 60GB free of space, after the WampServer installation.
Thanks for the advice. smiling smiley

Options: ReplyQuote


Sorry, only registered users may post in this forum.