WampServer

#2002 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

The server is not responding (or the local server's socket is not correctly configured).

Please help me the issue



Edited 1 time(s). Last edit at 04/05/2016 04:31PM by Otomatic.

Hi Rajeeb

Please answer these questions READ BEFORE YOU ASK A QUESTION

Then check the TROUBLE SHOOTING TIPS

And if yo are using WAMPServer 3 also check WAMPServer 3 All you need to know

If that does not help, then please as a question with more context in it as we are not clairvoyant.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

My wampserver icon is shows green, but I don't what is the problem is.....
it will better for me can you please solve the issue step by step.

My configuration is:

Windows 10 32 bit - Apche 2.4.9 - PHP 5.5.12 - MySQL 5.6.17

Hi,

Please:
- FIRST, answer to ALL questions : READ BEFORE YOU ASK A QUESTION

- SECONDLY : You wrote there is an error : #2002 - A connection attempt failed because the connected...
Thank you explain exactly how and by what, this error occurs.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I am unable to connect the phpmyadmin. please sort it out as soon as possible.

- FIRST, answer to ALL questions : READ BEFORE YOU ASK A QUESTION

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

How can I answer to ALL questions, I am already told that

1. (W10 32 bit)
2. Wampserver 2.5
3. Apache Version :2.4.9
4. PHP Version :5.5.12
5. Server Software:Apache/2.4.9 (Win32) PHP/5.5.12
6. MySQL Version :5.6.17
7. My Wampserver shows green icon.

I am unable to connect the phpmyadmin. It shows Access denied. The message is:

#2002 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

The server is not responding (or the local server's socket is not correctly configured).

This sounds like MYSQL is not actually running, or maybe you have another MYSQL Server installed on your system.

Did you try to install MYSQL manually before trying WAMPServer?

Look at Windows Services
CTRL+R
Enter services.msc
Press the OK button

WAMPServers MySQL service is called `wampmysqld`

If you installed MYSQL another way there may also be a service called just `MYSQL`

If this is the case, the solution is to uninstall the other MYSQL Server, after backing up any databases you may want to keep. You can then restore those databases to the WAMPServer MYSQL Server

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi,

Not at ALL !

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.

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

Do you have access to the MySQL Console?
- Wampmanager Tray Icon -> MySQL -> MySQL Console
At the password prompt hit Return key as there is no password.

See errors (error only, not all messages) in wamp\logs\mysql.log file.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

The MySQL Error log is:
2016-04-07 10:49:29 4120 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-07 10:49:29 4120 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-07 10:49:29 4120 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-04-07 10:49:29 4120 [Note] InnoDB: Completed initialization of buffer pool
2016-04-07 10:49:29 4120 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-07 10:49:29 4120 [Note] InnoDB: The log sequence numbers 1626134 and 1626134 in ibdata files do not match the log sequence number 1626144 in the ib_logfiles!
2016-04-07 10:49:29 4120 [Note] InnoDB: Database was not shutdown normally!
2016-04-07 10:49:29 4120 [Note] InnoDB: Starting crash recovery.
2016-04-07 10:49:29 4120 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-04-07 10:49:30 4120 [Note] InnoDB: Restoring possible half-written data pages
2016-04-07 10:49:30 4120 [Note] InnoDB: from the doublewrite buffer...
2016-04-07 10:49:31 4120 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-07 10:49:31 4120 [Note] InnoDB: Waiting for purge to start
2016-04-07 10:49:31 4120 [Note] InnoDB: 5.6.17 started; log sequence number 1626144
2016-04-07 10:49:31 4120 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-07 10:49:31 4120 [Note] IPv6 is available.
2016-04-07 10:49:31 4120 [Note] - '::' resolves to '::';
2016-04-07 10:49:31 4120 [Note] Server socket created on IP: '::'.
2016-04-07 10:49:34 4120 [Note] Event Scheduler: Loaded 0 events
2016-04-07 10:49:34 4120 [Note] wampmysqld: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)

Hi,

Why do you answer half of the questions put to you?

Do you have access to the MySQL Console?
- Wampmanager Tray Icon -> MySQL -> MySQL Console
At the password prompt hit Return key as there is no password.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Well apart from the successful crash recovery messages that shows a normal MYSQL startup.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Yes I have access to the MySQL Console

When I Wampmanager Tray Icon -> phpMyAdmin

It shows the access denied and got the message:

#2002 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

The server is not responding (or the local server's socket is not correctly configured).

Hi,

What are the lines without # at the beginning in C:\Windows\System32\drivers\etc\hosts file

For information: It is question N°7 of READ BEFORE YOU ASK A QUESTION

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Only 1 # line
the hosts file is given below:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost

127.0.0.1 localhost

Hi,

- Mysql log said :
2016-04-07 10:49:31 4120 [Note] - '::' resolves to '::';
2016-04-07 10:49:31 4120 [Note] Server socket created on IP: '::'.

That is to say that MySQL is connected with a socket IPv6

- Error said :
... or the local server's socket is not correctly configured).

In the c:\windows\system32\drivers\etc\hosts file you need to have only this two lines :

127.0.0.1 localhost
::1 localhost

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I am add the two lines:

127.0.0.1 localhost
::1 localhost

still now same issue

Hi,

Sorry, but the contents of the hosts file is not taken into account by Windows just after editing it!

For this to be taken into account, you have two options:
- 1 - Quit Wampserver then restart Windows.

- 2 - Quit Wampserver
- Open a command Windows as an administrator
- In the command Windows type the following commands

ipconfig /flushdns
net stop dnscache
net start dnscache

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I just follow your step but still now we have face the same issue .

Access denied

#2002 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

The server is not responding (or the local server's socket is not correctly configured).

Can you please solve this issue by remote ?? like ammyy or show my pc