phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 19, 2016 09:20AM

Hi,

After performing a fresh installation of WAMPServer 3 and the necessary C++ files, i was unable to login via phpMyAdmin (with root and blank password) and start MySQL service (MySQL -> service administration -> start service) even after reinstalling the services and wamp. I wasn't able to login via phpMyAdmin. Icon is orange

1- Windows 10 education version 1607 (64 bit) (running via boot camp if it matters)
2- WampServer 3.0.6 64 bit
3- Apache v 2.4.23
4- php v 5.6.25
5-mysql v 5.7.14
6- WampServer icon is orange

php error log and apache access log is empty.

Apache error log gave me this:

[mpm_winnt:notice] [pid 1980:tid 616] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[mpm_winnt:notice] [pid 6296:tid 448] AH00364: Child: All worker threads have exited.
[mpm_winnt:notice] [pid 1980:tid 616] AH00430: Parent: Child process 6296 exited successfully.
[auth_digest:notice] [pid 6724:tid 536] AH01757: generating secret for digest authentication ...
[mpm_winnt:notice] [pid 6724:tid 536] AH00455: Apache/2.4.23 (Win64) PHP/7.0.10 configured -- resuming normal operations
[mpm_winnt:notice] [pid 6724:tid 536] AH00456: Apache Lounge VC14 Server built: Jul 1 2016 11:43:51
[core:notice] [pid 6724:tid 536] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.23\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.23'
[mpm_winnt:notice] [pid 6724:tid 536] AH00418: Parent: Created child process 6688
[auth_digest:notice] [pid 6688:tid 492] AH01757: generating secret for digest authentication ...
[mpm_winnt:notice] [pid 6688:tid 492] AH00354: Child: Starting 64 worker threads.



On the MySQL.log file these were the error logs:

[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.
[ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
[ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Failed to initialize plugins.
[ERROR] Aborting



7- No active lines with localhost in the hosts file

8 & 9- didn't managed have my WampServer icon to be green after installation

10- These errors in the event viewer as well:

InnoDB: Operating system error number 87 in a file operation.For more information, see Help and Support Center at [www.mysql.com].
InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operationFor more information, see Help and Support Center at [www.mysql.com].
InnoDB: Cannot continue operation.For more information, see Help and Support Center at [www.mysql.com].

11- didn't install any antivirus and disabled firewall
12- Full path of installation is at C:\wamp64\
13- I only could see localhost under my virtual host.



Edited 5 time(s). Last edit at 12/23/2016 03:42AM by ashhao1000.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: Otomatic (Moderator)
Date: December 19, 2016 09:27AM

Hi,

Please, READ (and answer) BEFORE YOU ASK A QUESTION

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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: phpMyAdmin error
Posted by: ashhao1000 (---.singnet.com.sg)
Date: December 20, 2016 11:30AM

Edited my post.

Thanks

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: RiggsFolly (Moderator)
Date: December 20, 2016 12:39PM

Hi

Looks like the install did not complete correctly.

Did you install WAMPServer "As Administrator"????

If not, Uninstall this WAMPServer, manually delete the \wamp folder

Then reinstall properly, you must launch the install exe use "Run as Administrator"

---------------------------------------------------------------------------------------------
(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.6.5.2> <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: phpMyAdmin error
Posted by: Otomatic (Moderator)
Date: December 20, 2016 02:47PM

Hi,

In my previous post, I asked you to answer a few questions: READ (and answer) BEFORE YOU ASK A QUESTION
You still have not answered.
If you do not do what you have asked for, do not be surprised at not having solutions to your problem.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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: phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 20, 2016 04:57PM

I did "Run as administrator" upon installation and upon launching the program but, it does not seem to work

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: RiggsFolly (Moderator)
Date: December 20, 2016 07:11PM

You have still NOT ANSWERED THE QUESTION Otomatic asked you to answer.

Please read that post and answer ALL the questions

---------------------------------------------------------------------------------------------
(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.6.5.2> <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: phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 21, 2016 02:20PM

Hi,

I read thru the post and the other posts that was inside the post. May I know which other information am i lacking of?

Thank you

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: Otomatic (Moderator)
Date: December 21, 2016 04:45PM

Hi,

> May I know which other information am i lacking of?
Put on your glasses or go to an ophthalmologist!
What is the content of : READ (and answer) BEFORE YOU ASK A QUESTION

--------------------------------------------------------------
Before asking a question, please read Toubleshooting Tips

And then if you are using WAMPServer3 also read WAMPServer 3 All you need to know


When you ask a question, please ensure you start your question with the answers to ALL these 13 questions.

1 - Windows version used (Specify version number AND whether 32 or 64 bit)
2 - Version WampServer (Specify version number AND whether 32 or 64 bit)
3 - Apache Version
4 - PHP Version
5 - MySQL Version
6 - What color is the WampServer icon (in the notification area of the taskbar)

When all goes well it should be green, but it may be red or orange.

If the WampServer icon is NOT GREEN please ensure you have looked at these files :-
a - Apache error log
-- ( wampmanager -> Apache -> Apache error log )
-- ( wampmanager -> Apache -> Apache access log )
b - MySQL error log ( wampmanager -> MySQL -> MySQL log )
c - PHP error log ( wampmanager -> PHP -> PHP error log )

Depending on the error, one or all of the above may be empty so also look at
d - The windows event viewer
--- Windows Key + R to launch the run dialog then enter eventvwr.exe and press the OK button
--- - On the left side of the windows click 'Windows Logs -> Applications'
--- - Look for the names 'Apache Service' or 'MySQL' in the Source column which have a error symbol in the first column.

If you find any errors that you cannot fix for yourself please post the COMPLETE EXACT error message in your question.


7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
* Active means no # at the beginning of the line.


If the WampServer icon is green:

8 - Do you have access to localhost (Homepage WampServer)?
9 - Do you have access to phpMyAdmin?

10 - If you refer to an error message, please include the EXACT wording of the error in your post
11 - If you use an Antivirus and / or Firewall, please include the names of these
12 - What is the full path to the installation of WampServer (eg D:\wamp\)
13 - If you have one or more Virtual Hosts defined, please show their definition(s)
-----------------------------------------------------

At a minimum, there are thirteen responses to be given.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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: phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 23, 2016 03:43AM

i made the edits and my first post with the 13 responses given.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: Otomatic (Moderator)
Date: December 23, 2016 09:31AM

Hi,

> i made the edits and my first post with the 13 responses given.
Except that nothing indicates that there are changes on a post when you log on the forum.
Moreover, instead of simply reading a detailed reply, one must read a message again; You do not facilitate the task of those who would like to help you.

And, the main information is almost hidden:
- You are using Windows 10 on a Mac with BootCamp.
I do not know if Wampserver (or any other WAMP) works correctly on a Mac with BootCamp.
Why do not you use a MAMP server directly

> 7- No active lines with localhost in the hosts file
In the file C:\Windows\System32\drivers\etc\hosts there must be two lines :
127.0.0.1 localhost
::1 localhost

Apache service is correctly started.
MySQL service is not started.

It seems that MySQL did not install correctly with a problem creating the data folder.

- 1 - Exit Wampmanager
- 2 - Delete the folder wamp/bin/mysql/mysql5.7.14/data/
- 3 - Open a command windows - as an administrator - on the folder wamp/bin/mysql/mysql5.7.14/bin/
- 4 - Type the command :
mysqld.exe --initialize-insecure
A new data forlder should be created within 30 sec.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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 2 time(s). Last edit at 12/23/2016 11:18AM by Otomatic.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 24, 2016 07:57AM

Hi

Apparently i tried installing on my older machine with using bootcamp on a Windows 7 OS, i could get the WampServer running green icon on first launch. I am quite forced to make use of WampServer instead of using Mamp though.

I added the 2 lines to my hosts files and also run the command via command prompt, but still getting the error results.



Edited 1 time(s). Last edit at 12/24/2016 09:13AM by ashhao1000.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: Otomatic (Moderator)
Date: December 24, 2016 10:05AM

Hi,

Did you install ALL VC++ packages needed ?
Point N°20 of TROUBLESHOOTING TIPS

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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: phpMyAdmin error
Posted by: ashhao1000 (---.29.86.116.starhub.net.sg)
Date: December 24, 2016 10:49AM

Hi,

Yes i did except for the Update for Universal C Runtime in Windows as i am running on Win 10 (and there isn't any installation for Win 10). I even reinstalled my entire bootcamp partition and reinstall all the VC++ packages needed.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: cliftonf (---.hsd1.fl.comcast.net)
Date: May 21, 2017 07:04PM

For anybody in the future with this same issue (i.e. windows 10 , mac, bootcamp )

If MySQL won't start and c:\wamp64\logs\mysql.log says:

[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.
[ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
[ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Failed to initialize plugins.
[ERROR] Aborting

This is what worked for me:


1) Run the installer and work through any issues with port 80 (skype, iis, etc ) and get apache working.

2) Follow the instructions in "c:\wamp64\read_after_install-english.txt" and install the entire microsoft mess. ( both x86 and x64 ) ( go to the forum and read the post READ BEFORE YOU ASK A QUESTION )

Also make sure "127.0.0.1 localhost" is defined in c:\windows\system32\drivers\etc\hosts

3) Uninstall wampserver from control panel.

4) Right click and run as administrator the installer again and if the wampserver icon is orange and mysql is not running:

5)
- Exit Wampmanager
- Open a cmd prompt as administrator and cd to c:\wamp64\bin\mysql\mysql5.7.##
- Delete the "data" folder
- cd to c:\wamp64\bin\mysql\mysql5.7.##\bin
- Type the command :
mysqld.exe --initialize-insecure
A new data folder should be created within 30 sec.

6) restart wampserver and it should be green.



Edited 1 time(s). Last edit at 05/21/2017 07:11PM by cliftonf.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: kashiffkhann (103.76.101.---)
Date: May 24, 2017 09:04AM

1 - i am using windows 7 64bit.

2 - have installed WAMP server Version 3.0.6 - 64bit

3 - Apache Version 2.4.23

4 - PHP Version 5.6.25

5 - MySQL Version 5.7.14

6 - The WAMP sertver icon is green.


a - Apache error
log{Wed May 24 11:25:02.856868 2017] [auth_digest:notice] [pid 4528:tid 324] AH01757: generating secret for digest authentication ...

[Wed May 24 11:25:03.003876 2017] [mpm_winnt:notice] [pid 4528:tid 324] AH00455: Apache/2.4.23 
(Win64) PHP/5.6.25 configured -- resuming normal operations [Wed May 24 11:25:03.004876 2017] [mpm_winnt:notice] [pid 4528:tid 324] AH00456: Apache Lounge VC14 

Server built: Jul  1 2016 11:43:51[Wed May 24 11:25:03.004876 2017] [core:notice] [pid 4528:tid 324] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.23\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.23' 
[Wed May 24 11:25:03.027878 2017] [mpm_winnt:notice] [pid 4528:tid 324] AH00418: Parent: Created child process 1180
[Wed May 24 11:25:03.942930 2017] [auth_digest:notice] [pid 1180:tid 156] AH01757: generating secret for digest authentication ...
[Wed May 24 11:25:04.052936 2017] [mpm_winnt:notice] [pid 1180:tid 156] AH00354: Child: Starting 64 worker threads.

b - MySQL error log ( NO ERROR)

c - PHP error log ( NO ERROR )

7 - I am having access to localhost (Homepage WampServer).

8a - There is no error message at the bottom of the page.

9 - phpMyAdmin is opening as a blank page with no error message(i am not capable of finding the issue why is so happening since last one month i am trying to find out please help )

10 - There are no error except errors in apache error log which i have already mentioned above

11 - I dont use any Antivirus or Firewall.

12 - path to the installation of WampServer (C:\wamp64)

13 - I have one Virtual Host.



Edited 1 time(s). Last edit at 05/24/2017 10:05AM by RiggsFolly.

Options: ReplyQuote
Re: phpMyAdmin error
Posted by: RiggsFolly (Moderator)
Date: May 24, 2017 10:06AM

Hi

Please check your FireWall. Is MySQL allowed access to port 3306.

---------------------------------------------------------------------------------------------
(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.6.5.2> <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


Sorry, only registered users may post in this forum.