Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 29, 2017 09:53AM

Hi,

I've installed wampserver when I try to go on my phpmyadmin I got the error:

#2002 - #2002 - Impossibile stabilire la connessione. Rifiuto persistente del computer di destinazione. — The server is not responding (or the local server's socket is not correctly configured).The server is not responding (or the local server's socket is not correctly configured).

Plus I do not why it reply the first error string in italian.... anyway, any suggestions?

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 29, 2017 10:37AM

Hi,

READ (and answer) BEFORE YOU ASK A QUESTION

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 29, 2017 03:58PM

1 - Windows version used: Windows 10 PRO x64
2 - Version WampServer: Version 3.1.0 - 64bit
3 - Aparche version: 2.4.7
4 - PHP Version: 5.6.31
5 - MySQL Version: 5.7.19
6 - What color is the WampServer icon: orange

I found only this errore on mysql.log
2017-10-29T08:49:19.317971Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2017-10-29T08:49:19.318974Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2017-10-29T08:49:19.319977Z 0 [ERROR] InnoDB: Cannot continue operation.
2017-10-29T14:51:36.678842Z 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-10-29T14:51:36.695980Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2017-10-29T14:51:36.701417Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-10-29T14:51:37.007265Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-10-29T14:51:37.007768Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-10-29T14:51:37.008799Z 0 [ERROR] Failed to initialize plugins.
2017-10-29T14:51:37.009272Z 0 [ERROR] Aborting

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 29, 2017 04:39PM

Hi,

Wampserver has not been installed correctly. MySQL does not want to start, corrupt database.
Either the necessary VC packages were not all installed, or you did not install "as administrator".

Uninstall Wampserver then :
- 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.

When all the necessary packages are installed, you can reinstall Wampserver "as administrator".

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 05:05AM

I've done everything. All pkgs installed, wamp removed and reinstalled in administrator.

Results:

Apache:
[Mon Oct 30 05:03:31.077360 2017] [mpm_winnt:notice] [pid 8108:tid 688] AH00455: Apache/2.4.27 (Win64) PHP/5.6.31 configured -- resuming normal operations
[Mon Oct 30 05:03:31.077360 2017] [mpm_winnt:notice] [pid 8108:tid 688] AH00456: Apache Lounge VC15 Server built: Jul 7 2017 12:46:00
[Mon Oct 30 05:03:31.077360 2017] [core:notice] [pid 8108:tid 688] AH00094: Command line: 'f:\\wamp64\\bin\\apache\\apache2.4.27\\bin\\httpd.exe -d F:/wamp64/bin/apache/apache2.4.27'
[Mon Oct 30 05:03:31.077360 2017] [mpm_winnt:notice] [pid 8108:tid 688] AH00418: Parent: Created child process 2756
[Mon Oct 30 05:03:31.466923 2017] [mpm_winnt:notice] [pid 2756:tid 664] AH00354: Child: Starting 64 worker threads.


PHP:
[30-Oct-2017 04:03:30 UTC] No error - Only to create the file


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

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 09:18AM

Hi,

Exit Wampserver.

With Files explorer, delete the totality of files and folders into wamp64\bin\mysql\mysql5.7.19\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 wamp64\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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 09:34AM

Same issue

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

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 10:03AM

Hi,

This procedure is the procedure defined by MySQL.

If it does not work, it means that you have a problem with your system or disk or anti-virus or that you are not up to date with Windows Update.

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 11:39AM

I just disabled the antivirus, deleted the "data" directory and reexecuted the cmd that you gave me... nothing to do
sad smiley

That is a bit annoying!!!



Edited 1 time(s). Last edit at 10/30/2017 11:43AM by Salvodif.

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 12:03PM

Hi,

We will try to use a MySQL 5.6.37 version for which there is no need to create the data folder, as it is an integral part of the distribution.

Donwload then run "as an administrator" the MySQL 5.6.37 64 bit addon:
[wampserver.aviatechno.net]

Launch Wampserver and even if tray icon is not green, do:
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Stop service
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Remove service

- Left-click wampmanager tray icon -> MySQL -> Version -> 5.6.37
May be icon goes green, il not :
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Install service
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Start/Resume service

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 02:33PM

I got a new error when I try to switch the mysql version:

Aestan Tray Menu

Could not execute menu item (internal error)
[Exception] Could not perform built-in action: No service has been opened yet!

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 02:56PM

Hi,

Exit Wampmanager.

Edit wamp64/wampmanager.conf
Replace
[mysql]
mysqlVersion = "5.7.19"
by
[mysql]
mysqlVersion = "5.6.37"
Save the modified file.

For the sake of awareness, open a command window "as administrator" and, in case the service has not been deleted, in this window type:
net stop wampmysqld64
sc delete wampmysqld64
There could be errors, ignore them.
Exit the command windows

Launch Wampserver.
As the MySQL service does not exist, the icon will not be green, too:
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Install service
- Left-click wampmanager tray icon -> MySQL -> Service administration -> Start/Resume service

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 03:05PM

I'm very sorry but nothing is still orange.

Btw I tried to delete the "data" directory from the new mysql ver and run the cmd as Administrator. That is what I got

F:\wamp64\bin\mysql\mysql5.6.37\bin>mysqld.exe --initialize-insecure
2017-10-30 15:01:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-30 15:01:09 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-10-30 15:01:09 0 [Note] mysqld.exe (mysqld 5.6.37) starting as process 4456 ...
2017-10-30 15:01:09 4456 [Warning] Can't create test file F:\wamp64\bin\mysql\mysql5.6.37\data\Hild¾rien.lower-test
2017-10-30 15:01:09 4456 [Warning] Can't create test file F:\wamp64\bin\mysql\mysql5.6.37\data\Hild¾rien.lower-test
mysqld.exe: Can't change dir to 'F:\wamp64\bin\mysql\mysql5.6.37\data\' (Errcode: 2 - No such file or directory)
2017-10-30 15:01:09 4456 [ERROR] Aborting

2017-10-30 15:01:09 4456 [Note] Binlog end
2017-10-30 15:01:09 4456 [Note] mysqld.exe: Shutdown complete

So I created the "data" directory again and run the command "mysqld.exe --initialize-insecure", I got:

2017-10-30 15:02:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-30 15:02:41 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-10-30 15:02:41 0 [Note] mysqld.exe (mysqld 5.6.37) starting as process 10172 ...

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 03:20PM

HI,

> Btw I tried to delete the "data" directory from the new mysql
Why ? It's a total mistake. The creation of the data folder can not be done under MySQL 5.6. This folder is part of the distribution and can not be recreated.
Did not I write:
« We will try to use a MySQL 5.6.37 version for which there is no need to create the data folder, as it is an integral part of the distribution. »

I repeat: you have a problem on your system. I do not know which.

Or you have another MySQL installation somewhere.
Follow : TROUBLESHOOTING TIPS

------------------------------------------------------------------------------------------------------------
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: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.190-82-b.business.telecomitalia.it)
Date: October 30, 2017 03:27PM

Tnx for everything Otomatic I'll give up.
I've no other MySql installed on my system anyway.

Tnx

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Salvodif (---.ip108.fastwebnet.it)
Date: October 30, 2017 06:07PM

Just last question: why MariaDB also doesn't run?
Can I install mysql from the standard installer?

Options: ReplyQuote
Re: Error 2002 phpMyAdmin brand new installation
Posted by: Otomatic (Moderator)
Date: October 30, 2017 06:26PM

Hi,

> Just last question: why MariaDB also doesn't run?
I don't know.
Your question is too general and imprecise.
We have to understand what you mean by "does not run".

Read wamp64/mariadb_support_en.txt

------------------------------------------------------------------------------------------------------------
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


Sorry, only registered users may post in this forum.