phpMyAdmin - Access Denied Error 2002
Posted by: madoxnola (---.no.no.cox.net)
Date: January 21, 2013 05:28PM

For some reason phpMyAdmin is not working anymore, I can view localhost with no problems, but when I start up phpMyAdmin I am getting an error 2002 Access denied.

Can you please give me some direction.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.as13285.net)
Date: January 21, 2013 10:09PM

Can you post one of the error mesages from Apache error log please, from this 2002 acess denied error

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: madoxnola (---.no.no.cox.net)
Date: January 22, 2013 07:00AM

Here is the error log for today.

Mon Jan 21 00:18:02 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 00:18:02 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 00:18:02 2013] [notice] Parent: Created child process 6332
[Mon Jan 21 00:18:02 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 00:18:02 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 00:18:02 2013] [notice] Child 6332: Child process is running
[Mon Jan 21 00:18:02 2013] [notice] Child 6332: Acquired the start mutex.
[Mon Jan 21 00:18:02 2013] [notice] Child 6332: Starting 64 worker threads.
[Mon Jan 21 00:18:02 2013] [notice] Child 6332: Starting thread to listen on port 80.
[Mon Jan 21 00:18:02 2013] [notice] Child 6332: Starting thread to listen on port 80.
[Mon Jan 21 00:50:21 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 00:50:21 2013] [notice] Child 6332: Exit event signaled. Child process is ending.
[Mon Jan 21 00:50:22 2013] [notice] Child 6332: Released the start mutex
[Mon Jan 21 00:50:23 2013] [notice] Child 6332: All worker threads have exited.
[Mon Jan 21 00:50:23 2013] [notice] Child 6332: Child process is exiting
[Mon Jan 21 00:50:23 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 09:22:00 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:22:00 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 09:22:00 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 09:22:00 2013] [notice] Parent: Created child process 5324
[Mon Jan 21 09:22:00 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:22:00 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:22:01 2013] [notice] Child 5324: Child process is running
[Mon Jan 21 09:22:01 2013] [notice] Child 5324: Acquired the start mutex.
[Mon Jan 21 09:22:01 2013] [notice] Child 5324: Starting 64 worker threads.
[Mon Jan 21 09:22:01 2013] [notice] Child 5324: Starting thread to listen on port 80.
[Mon Jan 21 09:22:01 2013] [notice] Child 5324: Starting thread to listen on port 80.
[Mon Jan 21 09:22:19 2013] [error] [client ::1] client denied by server configuration: E:/clients/wamp/apps/phpmyadmin3.4.10.1/, referer: [localhost]
[Mon Jan 21 09:22:19 2013] [error] [client ::1] File does not exist: E:/clients/wamp/www/favicon.ico
[Mon Jan 21 09:22:20 2013] [error] [client ::1] File does not exist: E:/clients/wamp/www/favicon.ico
[Mon Jan 21 09:22:37 2013] [error] [client ::1] client denied by server configuration: E:/clients/wamp/apps/phpmyadmin3.4.10.1/, referer: [localhost]
[Mon Jan 21 09:22:58 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 09:22:58 2013] [notice] Child 5324: Exit event signaled. Child process is ending.
[Mon Jan 21 09:22:59 2013] [notice] Child 5324: Released the start mutex
[Mon Jan 21 09:23:00 2013] [notice] Child 5324: All worker threads have exited.
[Mon Jan 21 09:23:00 2013] [notice] Child 5324: Child process is exiting
[Mon Jan 21 09:23:00 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 09:23:01 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:23:01 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 09:23:01 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 09:23:01 2013] [notice] Parent: Created child process 6996
[Mon Jan 21 09:23:01 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:23:01 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:23:01 2013] [notice] Child 6996: Child process is running
[Mon Jan 21 09:23:01 2013] [notice] Child 6996: Acquired the start mutex.
[Mon Jan 21 09:23:01 2013] [notice] Child 6996: Starting 64 worker threads.
[Mon Jan 21 09:23:01 2013] [notice] Child 6996: Starting thread to listen on port 80.
[Mon Jan 21 09:23:01 2013] [notice] Child 6996: Starting thread to listen on port 80.
[Mon Jan 21 09:23:37 2013] [error] [client ::1] client denied by server configuration: E:/clients/wamp/apps/phpmyadmin3.4.10.1/, referer: [localhost]
[Mon Jan 21 09:23:40 2013] [error] [client ::1] File does not exist: E:/clients/wamp/www/phpmyadmin-bk, referer: [localhost]
[Mon Jan 21 09:26:55 2013] [error] [client ::1] client denied by server configuration: E:/clients/wamp/apps/phpmyadmin3.4.10.1/
[Mon Jan 21 09:38:08 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 09:38:08 2013] [notice] Child 6996: Exit event signaled. Child process is ending.
[Mon Jan 21 09:38:09 2013] [notice] Child 6996: Released the start mutex
[Mon Jan 21 09:38:10 2013] [notice] Child 6996: All worker threads have exited.
[Mon Jan 21 09:38:10 2013] [notice] Child 6996: Child process is exiting
[Mon Jan 21 09:38:10 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 09:45:56 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:45:56 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 09:45:56 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 09:45:56 2013] [notice] Parent: Created child process 3292
[Mon Jan 21 09:45:57 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:45:57 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:45:57 2013] [notice] Child 3292: Child process is running
[Mon Jan 21 09:45:57 2013] [notice] Child 3292: Acquired the start mutex.
[Mon Jan 21 09:45:57 2013] [notice] Child 3292: Starting 64 worker threads.
[Mon Jan 21 09:45:57 2013] [notice] Child 3292: Starting thread to listen on port 80.
[Mon Jan 21 09:45:57 2013] [notice] Child 3292: Starting thread to listen on port 80.
[Mon Jan 21 09:53:57 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 09:53:57 2013] [notice] Child 3292: Exit event signaled. Child process is ending.
[Mon Jan 21 09:53:58 2013] [notice] Child 3292: Released the start mutex
[Mon Jan 21 09:53:59 2013] [notice] Child 3292: All worker threads have exited.
[Mon Jan 21 09:53:59 2013] [notice] Child 3292: Child process is exiting
[Mon Jan 21 09:53:59 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 09:53:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:53:59 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 09:53:59 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 09:53:59 2013] [notice] Parent: Created child process 2764
[Mon Jan 21 09:53:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:54:00 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 09:54:00 2013] [notice] Child 2764: Child process is running
[Mon Jan 21 09:54:00 2013] [notice] Child 2764: Acquired the start mutex.
[Mon Jan 21 09:54:00 2013] [notice] Child 2764: Starting 64 worker threads.
[Mon Jan 21 09:54:00 2013] [notice] Child 2764: Starting thread to listen on port 80.
[Mon Jan 21 09:54:00 2013] [notice] Child 2764: Starting thread to listen on port 80.
[Mon Jan 21 09:54:33 2013] [error] [client 127.0.0.1] File does not exist: E:/clients/wamp/www/favicon.ico
[Mon Jan 21 10:01:09 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 10:01:09 2013] [notice] Child 2764: Exit event signaled. Child process is ending.
[Mon Jan 21 10:01:10 2013] [notice] Child 2764: Released the start mutex
[Mon Jan 21 10:01:11 2013] [notice] Child 2764: All worker threads have exited.
[Mon Jan 21 10:01:11 2013] [notice] Child 2764: Child process is exiting
[Mon Jan 21 10:01:11 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 10:01:11 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:11 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 10:01:11 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 10:01:11 2013] [notice] Parent: Created child process 4576
[Mon Jan 21 10:01:11 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:11 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:11 2013] [notice] Child 4576: Child process is running
[Mon Jan 21 10:01:11 2013] [notice] Child 4576: Acquired the start mutex.
[Mon Jan 21 10:01:11 2013] [notice] Child 4576: Starting 64 worker threads.
[Mon Jan 21 10:01:11 2013] [notice] Child 4576: Starting thread to listen on port 80.
[Mon Jan 21 10:01:11 2013] [notice] Child 4576: Starting thread to listen on port 80.
[Mon Jan 21 10:01:56 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 10:01:56 2013] [notice] Child 4576: Exit event signaled. Child process is ending.
[Mon Jan 21 10:01:57 2013] [notice] Child 4576: Released the start mutex
[Mon Jan 21 10:01:58 2013] [notice] Child 4576: All worker threads have exited.
[Mon Jan 21 10:01:58 2013] [notice] Child 4576: Child process is exiting
[Mon Jan 21 10:01:58 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 10:01:58 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:58 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 10:01:58 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 10:01:58 2013] [notice] Parent: Created child process 4712
[Mon Jan 21 10:01:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 10:01:59 2013] [notice] Child 4712: Child process is running
[Mon Jan 21 10:01:59 2013] [notice] Child 4712: Acquired the start mutex.
[Mon Jan 21 10:01:59 2013] [notice] Child 4712: Starting 64 worker threads.
[Mon Jan 21 10:01:59 2013] [notice] Child 4712: Starting thread to listen on port 80.
[Mon Jan 21 10:01:59 2013] [notice] Child 4712: Starting thread to listen on port 80.
[Mon Jan 21 10:22:23 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Jan 21 10:22:23 2013] [notice] Child 4712: Exit event signaled. Child process is ending.
[Mon Jan 21 10:22:24 2013] [notice] Child 4712: Released the start mutex
[Mon Jan 21 10:22:25 2013] [notice] Child 4712: All worker threads have exited.
[Mon Jan 21 10:22:25 2013] [notice] Child 4712: Child process is exiting
[Mon Jan 21 10:22:25 2013] [notice] Parent: Child process exited successfully.
[Mon Jan 21 23:58:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 23:58:59 2013] [notice] Apache/2.2.21 (Win64) PHP/5.3.10 configured -- resuming normal operations
[Mon Jan 21 23:58:59 2013] [notice] Server built: Sep 24 2011 19:57:51
[Mon Jan 21 23:58:59 2013] [notice] Parent: Created child process 5980
[Mon Jan 21 23:58:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 23:58:59 2013] [warn] The Alias directive in E:/clients/wamp/alias/phpmyadmin.conf at line 1 will probably never match because it overlaps an earlier Alias.
[Mon Jan 21 23:58:59 2013] [notice] Child 5980: Child process is running
[Mon Jan 21 23:58:59 2013] [notice] Child 5980: Acquired the start mutex.
[Mon Jan 21 23:58:59 2013] [notice] Child 5980: Starting 64 worker threads.
[Mon Jan 21 23:58:59 2013] [notice] Child 5980: Starting thread to listen on port 80.
[Mon Jan 21 23:58:59 2013] [notice] Child 5980: Starting thread to listen on port 80.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: madoxnola (---.no.no.cox.net)
Date: January 22, 2013 03:39PM

I tried re-installing wampserver over the old one and I am still getting the error:
MySQL Said, #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.as13285.net)
Date: January 24, 2013 02:03AM

This is your problem

[Mon Jan 21 09:26:55 2013] [error] [client ::1] client denied by server configuration:

The ::1 address indicates that you are connecting to apache on the IPV6 network. W7 & W8 come with IPV6 configured but wamp I am afraid has not caught up yet.

All the wamp security is based on IPV4 address's like 127.0.0.1 and not ::1


Solution is:

edit c:\windows\system32\drivers\etc\hosts ( no extension ) using an editor you have launched using "Run as Administrator" or you wont be able to save your changes.

Make sure it has
127.0.0.1 localhost

and if it has
::1 localhost
remove it or comment it out with a #

then
left click wampmanager icon -> Apache -> httpd.conf
this will launch notpad to edit the Apache config file

Look for 'Listen' and change it to 'Listen 0.0.0.0:80'

reboot

And try again

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: tusherr (---.banglalionwimax.com)
Date: January 24, 2013 06:01AM

130124 10:58:22 [Note] Plugin 'FEDERATED' is disabled.
130124 10:58:22 InnoDB: The InnoDB memory heap is disabled
130124 10:58:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130124 10:58:22 InnoDB: Compressed tables use zlib 1.2.3
130124 10:58:22 InnoDB: Initializing buffer pool, size = 128.0M
130124 10:58:22 InnoDB: Completed initialization of buffer pool
130124 10:58:22 InnoDB: highest supported file format is Barracuda.
130124 10:58:22 InnoDB: Waiting for the background threads to start
130124 10:58:23 InnoDB: 1.1.8 started; log sequence number 10150619
130124 10:58:24 [Note] Event Scheduler: Loaded 0 events
130124 10:58:24 [Note] wampmysqld: ready for connections.
Version: '5.5.16-log' socket: '' port: 3306 MySQL Community Server (GPL)

could not open myPHPadmin !!!
it was working lat 6 months long!! suddenly it start to show error?
please suggest quickly, what can I do?

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: frankluo (116.7.100.---)
Date: January 24, 2013 09:05AM

edit c:\windows\system32\drivers\etc\hosts ( no extension ) using an editor you have launched using "Run as Administrator"

left click wampmanager icon -> Apache -> httpd.conf
this will launch notpad to edit the Apache config file

Look for 'Listen' and change it to 'Listen 0.0.0.0:80'

reboot the software

(ANSWER BY RIGGSFOLLY)



Edited 3 time(s). Last edit at 01/27/2013 08:54AM by stevenmartin99.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.as13285.net)
Date: January 24, 2013 02:41PM

Hey Frank,

Is plagiarism still the highest form of philately ??

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: karthick-sk (117.193.213.---)
Date: January 27, 2013 07:30AM

Also try this, your MySQL user root might have been set password.

the config will be in wamp/apps/phpmyadmin<version>/config.inc

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.as13285.net)
Date: January 27, 2013 03:17PM

tusher,

Do you still have this problem?
If so post some of your php error log that woudl be more informative than your mysql error log. phpmyadmin is afterall a php application.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: 3rktg (---.lsanca.dsl-w.verizon.net)
Date: February 06, 2013 12:42AM

Hi Riggis,
I can not access phpmyadmin by clicking on "phpmyadmin" through wamp server. It shows

MySQL said:

#2002 - No connection could be made because the target machine actively refused it.

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



I have changed httpd.conf from listen 80 to listen 0.0.0.0:80

I can access phpmyadmin if I type "[127.0.0.1];

My system is 64-bit, windows 7, the wamp server was running OK last week but it stopped working yesterday after I installed a joomla 1.5 template... I uninstalled the wamp server and reinstalled it.... now I can not access phpmyadmin...

Please help

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: 3rktg (---.lsanca.dsl-w.verizon.net)
Date: February 06, 2013 01:07AM

For some reasons, after I used [127.0.0.1] to config wordPress. I can access phpmyadmin through [localhost] now

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: Yuma (---.pool-125-25.dynamic.totbb.net)
Date: March 30, 2013 06:13AM

I also get this 2002 error if try to open phpmyadmin from the wamp icon. If I just use the browser to go to 127.0.0.1 then click phpmyadmin on the wampserver home page it works !! My hosts file is fine, I cannot understand it tongue sticking out smiley

Any thoughts ?

Using win 7 64bit - wamp 2.2



Edited 2 time(s). Last edit at 03/30/2013 06:16AM by Yuma.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: lucycandy (192.0.25.---)
Date: April 01, 2013 10:06AM

That sounds good. Any thing but the same ww over again.






___________________________________________
wow gold|diablo 3 gold|wow gold kaufen|GW2 Gold

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.as13285.net)
Date: April 02, 2013 12:35PM

Right, Windows as of Windows7 comes with the ability to use the IPV4 network address range and the IPV6 network address range and by default they are both turned on.
IPV4 addresses look like this: 123.321.10.234
IPV6 addresses look like this: 2001:0db8:85a3:0042:1000:8a2e:0370:7334

The IPV4 address for localhost is 127.0.0.1
The IPV6 address for localhost is ::1


See
[en.wikipedia.org]
[en.wikipedia.org]
[en.wikipedia.org]


However, Wamp's security as of now ( Feb 2013 ) is only configured to expect the IPV4 address range, but the Apache that is delivered with WAMPServer is aware of both the IPV4 and IPV6 address ranges and is happy to use either or in fact both.
I am not sure how Windows/Browsers decide which range to use but it appears to be fairly arbitrary, so you can get either.

This is the route of your problem.

There are 2 ways you can go to solve this small anomily. You can either ignore the IPV6 address range or change the security to include the IPV6 address range.


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
KEEP COPIES OF ALL FILES CHANGED SO YOU CAN EASILY UNDO THESE CHANGES IF THEY DO NOT WORK FOR YOU

In fact copy c:\wamp to a backup location and then you can just replace
the whole folder if you have problems with your changes.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Option 1 is easier to do.
==============================================================

Option 1:
Ignore the IPV6 address range.


Use the wamp menus to edit these files where possible.

edit httpd.conf
change Listen 80 TO Listen 0.0.0.0:80
The 0.0.0.0 part tells Apache to only listen on IPV4 addresses.


edit c:\windows\system32\drivers\etc\hosts
If it exists, remove or comment out (comment is a # in colum 1) the line containing the IPV6 address for localhost >::1 localhost
(This makes the domain 'localhost' disappear from the IPV6 network, its existance is not hard coded anywhere it has to be mentioned in the hosts file to make it exists)
Make sure you have a line in the hosts file like this >127.0.0.1 localhost
(This makes the domain 'localhost' exists on the IPV4 network)

Wamps security should now work after a reboot. And
http://localhost
should now get you to wamps Apache installation. The exisiting security should also now work for phpMyAdmin,WebGrind and SQLBuddy


============================================================
Option 2:
Add the IPV6 address range to wamps security.


Again always use the wamp menus to edit these files where possible.

!!!! Make sure WAMP is set to 'Offline' before starting this part.


Now this is the dangerous bit!!!!! You must get these next 2 edits right. The text between the double quotes in C:\wamp\scripts\onlineOffline.php must match exactly that used in the httpd.conf file, so a copy and paste would be recommended. If you get this wrong the Online/Offline process will not work.

edit httpd.conf

Change
# onlineoffline tag - don't remove
Order Deny,Allow
Deny from all
Allow from 127.0.0.1

TO
# onlineoffline tag - don't remove
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 ::1

Note we have added the ::1 IPV6 localhost address to the security, make sure there is a space between 127.0.0.1 and ::1.


Edit C:\wamp\scripts\onlineOffline.php
Change

$offlineText = "# onlineoffline tag - don't remove
Order Deny,Allow
Deny from all
Allow from 127.0.0.1";

TO

$offlineText = "# onlineoffline tag - don't remove
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 ::1";

This makes sure that the Online/Offline process still works in WampServer. Make sure that this exactly matches your change above made to httpd.conf


Now edit each of the files
C:\wamp\alias\phpmyadmin.conf
C:\wamp\alias\sqlbuddy.conf
C:\wamp\alias\webgrind.conf

were ever you see >127.0.0.1 change it to >127.0.0.1 ::1
Ignore the lines that start with a #, as these are comment lines

This tells Wamp that whichever ip address from either address range you get for the domain localhost, is allowed to access the apache server.
Now whichever address range windows/browser picks for you when you use the
http://localhost
domain the security will allow you in.

edit c:\windows\system32\drivers\etc\hosts
In Windows8 you will probably see both domains in the file, but this is not guaranteed. When you are finished it should look like this.

127.0.0.1 localhost
::1 localhost

This makes the domain localhost appear on both the IPV4 and IPV6 address ranges.


When you get as far as accessing MySQL you will see that the 'root' user is configured so that it can be accesses from localhost and 127.0.0.1 and ::1 so that is all ready to go and needs no changes.

If you decide to change the password for the 'root' userid in mysql, make sure you use the same password for all the instances of root that exist in mysql. A complete MySQL userid is associated with a location, so it is not the same userid when you login from root@127.0.0.1 as when you login from root@::1. This is why there are 3 'root' userids in the default MySQL userid configiration.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: ficuskk (---.live.vodafone.in)
Date: June 08, 2013 04:21AM

My localhost is looking good. When phpMyAdmin is accessed it gives error

Error

MySQL said: Documentation
#2002 - No connection could be made because the target machine actively refused it.

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





Can you please help



Edited 2 time(s). Last edit at 06/08/2013 04:26AM by ficuskk.

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: ficuskk (101.63.152.---)
Date: June 09, 2013 07:23PM

Hi Riggs,

I tried all your solution mentioned. I am using Windows XP with Service pack 2. 32 bit wampserver 2.2

Options: ReplyQuote
Re: phpMyAdmin - Access Denied Error 2002
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: June 10, 2013 01:06PM

What colour is your wampmanager icon in the system tray?

Options: ReplyQuote


Sorry, only registered users may post in this forum.