Forbiden PHPMyAdmin
Posted by: GroovyG (---.20-1.cable.virginm.net)
Date: March 22, 2014 03:19PM

Hi all,

I have been using WAMP for a few years without problem and just recently had to re-install Windows so I thought I would give xamp a go.

The problem I had was; when I tried to change the root password something went wrong and it wouldn't let me access PHPMyAdmin again, I was locked out.

It's safe to say I didn't like it so un-installed it and installed WAMP. Once all the services were running I tried to log into PHPMyAdmin but all I get is;

"Forbidden

You don't have permission to access /phpmyadmin/ on this server."

I have tried un-installing and re-installing it but I get the same.

I am running Windows 8 64bit.

Any ideas?

Thanks

Options: ReplyQuote
Re: Forbiden PHPMyAdmin
Posted by: RiggsFolly (---.as13285.net)
Date: March 22, 2014 04:56PM

Check this file

\wamp\alias\phpmyadmin.conf

You dont mention what version of WAMP you installled or the versions of Apache/MySQL & PHP, always heplful.

So if you are using Apache 2.2.x find this line

Allow from 127.0.0.1

and change it to

Allow from 127.0.0.1 localhost ::1


If you are using Apache 2.4.x

change it to
Require local

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

Options: ReplyQuote
Re: Forbiden PHPMyAdmin
Posted by: GroovyG (---.20-1.cable.virginm.net)
Date: March 22, 2014 05:51PM

Hi RiggsFolly

Thanks for your help, I tried what you suggested but it is still the same (I have tried stopping and starting the WAMP services).

Sorry you are right I should have said what versions I have, they are :

Apache Version: 2.2.22
PHP Version: 5.3.13
MySQL Version: 5.5.24

I just found the apache_error.log and it says this:

[Sat Mar 22 13:51:55 2014] [notice] Apache/2.2.22 (Win64) PHP/5.3.13 configured -- resuming normal operations
[Sat Mar 22 13:51:55 2014] [notice] Server built: May 13 2012 19:41:17
[Sat Mar 22 13:51:55 2014] [notice] Parent: Created child process 16408
[Sat Mar 22 13:51:55 2014] [notice] Child 16408: Child process is running
[Sat Mar 22 13:51:55 2014] [notice] Child 16408: Acquired the start mutex.
[Sat Mar 22 13:51:55 2014] [notice] Child 16408: Starting 64 worker threads.
[Sat Mar 22 13:51:55 2014] [notice] Child 16408: Starting thread to listen on port 80.
[Sat Mar 22 13:51:55 2014] [notice] Child 16408: Starting thread to listen on port 80.
[Sat Mar 22 13:51:59 2014] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat Mar 22 13:51:59 2014] [notice] Child 16408: Exit event signaled. Child process is ending.
[Sat Mar 22 13:52:00 2014] [notice] Child 16408: Released the start mutex
[Sat Mar 22 13:52:01 2014] [notice] Child 16408: All worker threads have exited.
[Sat Mar 22 13:52:01 2014] [notice] Child 16408: Child process is exiting
[Sat Mar 22 13:52:01 2014] [notice] Parent: Child process exited successfully.
[Sat Mar 22 13:52:01 2014] [notice] Apache/2.2.22 (Win64) PHP/5.3.13 configured -- resuming normal operations
[Sat Mar 22 13:52:01 2014] [notice] Server built: May 13 2012 19:41:17
[Sat Mar 22 13:52:01 2014] [notice] Parent: Created child process 16148
[Sat Mar 22 13:52:01 2014] [notice] Child 16148: Child process is running
[Sat Mar 22 13:52:01 2014] [notice] Child 16148: Acquired the start mutex.
[Sat Mar 22 13:52:01 2014] [notice] Child 16148: Starting 64 worker threads.
[Sat Mar 22 13:52:01 2014] [notice] Child 16148: Starting thread to listen on port 80.
[Sat Mar 22 13:52:01 2014] [notice] Child 16148: Starting thread to listen on port 80.
[Sat Mar 22 13:52:04 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/
[Sat Mar 22 14:02:32 2014] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/localhost
[Sat Mar 22 14:02:33 2014] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Sat Mar 22 14:02:49 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/, referer: [localhost]
[Sat Mar 22 14:11:31 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/
[Sat Mar 22 14:30:15 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/
[Sat Mar 22 14:32:39 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/webgrind1.0/
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\\wamp\\www\\testmysql.php on line 2
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Stack trace:
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 1. {main}() C:\\wamp\\www\\testmysql.php:0
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 2. mysql_connect() C:\\wamp\\www\\testmysql.php:2
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: [2002] php_network_getaddresses: getaddrinfo failed: No such host is known. (trying to connect via tcp://hostname:3306) in C:\\wamp\\www\\testmysql.php on line 2
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Stack trace:
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 1. {main}() C:\\wamp\\www\\testmysql.php:0
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 2. mysql_connect() C:\\wamp\\www\\testmysql.php:2
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\\wamp\\www\\testmysql.php on line 2
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Stack trace:
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 1. {main}() C:\\wamp\\www\\testmysql.php:0
[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP 2. mysql_connect() C:\\wamp\\www\\testmysql.php:2
[Sat Mar 22 14:37:24 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/webgrind1.0/
[Sat Mar 22 14:45:38 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:41 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:43 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:45 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:47 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:49 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:51 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:53 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:55 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:57 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:45:59 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:01 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:03 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:05 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:08 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:10 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:12 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:14 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:16 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:18 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:20 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:22 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:24 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:26 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:28 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:30 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:32 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:35 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:37 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:39 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:41 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:43 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:45 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:47 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:49 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:51 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:53 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:55 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:46:57 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:00 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:02 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:04 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:06 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:08 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:10 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:12 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:14 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:16 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:18 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:20 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:22 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:24 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:27 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:29 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:31 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:33 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:35 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:37 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:39 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:41 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:43 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:46 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:48 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:50 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:52 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:54 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:56 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:47:58 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:00 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:02 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:04 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:06 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:09 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:11 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:13 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:15 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:17 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:19 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 14:48:21 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc
[Sat Mar 22 16:34:55 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/
[Sat Mar 22 16:34:56 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/
[Sat Mar 22 16:35:22 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/, referer: [localhost]
[Sat Mar 22 16:35:25 2014] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat Mar 22 16:35:25 2014] [notice] Child 16148: Exit event signaled. Child process is ending.
[Sat Mar 22 16:35:26 2014] [notice] Child 16148: Released the start mutex
[Sat Mar 22 16:35:29 2014] [notice] Child 16148: All worker threads have exited.
[Sat Mar 22 16:35:29 2014] [notice] Child 16148: Child process is exiting
[Sat Mar 22 16:35:29 2014] [notice] Parent: Child process exited successfully.
[Sat Mar 22 16:35:29 2014] [notice] Apache/2.2.22 (Win64) PHP/5.3.13 configured -- resuming normal operations
[Sat Mar 22 16:35:29 2014] [notice] Server built: May 13 2012 19:41:17
[Sat Mar 22 16:35:29 2014] [notice] Parent: Created child process 4628
[Sat Mar 22 16:35:29 2014] [notice] Child 4628: Child process is running
[Sat Mar 22 16:35:29 2014] [notice] Child 4628: Acquired the start mutex.
[Sat Mar 22 16:35:29 2014] [notice] Child 4628: Starting 64 worker threads.
[Sat Mar 22 16:35:29 2014] [notice] Child 4628: Starting thread to listen on port 80.
[Sat Mar 22 16:35:29 2014] [notice] Child 4628: Starting thread to listen on port 80.
[Sat Mar 22 16:35:41 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/, referer: [localhost]
[Sat Mar 22 16:37:28 2014] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat Mar 22 16:37:28 2014] [notice] Child 4628: Exit event signaled. Child process is ending.
[Sat Mar 22 16:37:29 2014] [notice] Child 4628: Released the start mutex
[Sat Mar 22 16:37:30 2014] [notice] Child 4628: All worker threads have exited.
[Sat Mar 22 16:37:30 2014] [notice] Child 4628: Child process is exiting
[Sat Mar 22 16:37:30 2014] [notice] Parent: Child process exited successfully.
[Sat Mar 22 16:37:41 2014] [notice] Apache/2.2.22 (Win64) PHP/5.3.13 configured -- resuming normal operations
[Sat Mar 22 16:37:41 2014] [notice] Server built: May 13 2012 19:41:17
[Sat Mar 22 16:37:41 2014] [notice] Parent: Created child process 16152
[Sat Mar 22 16:37:41 2014] [notice] Child 16152: Child process is running
[Sat Mar 22 16:37:41 2014] [notice] Child 16152: Acquired the start mutex.
[Sat Mar 22 16:37:41 2014] [notice] Child 16152: Starting 64 worker threads.
[Sat Mar 22 16:37:41 2014] [notice] Child 16152: Starting thread to listen on port 80.
[Sat Mar 22 16:37:41 2014] [notice] Child 16152: Starting thread to listen on port 80.
[Sat Mar 22 16:37:57 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/, referer: [localhost]


Sorry for the large amount of data, I couldn't find anything showing how to embed code or anything, perhaps this should be added to the reply box for things like Bold, Italic etc

Thanks

Options: ReplyQuote
Re: Forbiden PHPMyAdmin
Posted by: RiggsFolly (---.as13285.net)
Date: March 24, 2014 12:18PM

[Sat Mar 22 13:52:04 2014] [error] [client ::1] client denied by server configuration: C:/wamp/apps/phpmyadmin3.5.1/

This is an IPV6 issue. I can only assume a recent update has activated IPV6 on your system, still no big deal.
Fix is to add the IPV6 equivalent of 127.0.0.1 to your config (::1)
edit \wamp\alias\phpmyadmin.conf and change this line

Allow from localhost

To

Allow from localhost 127.0.0.1 ::1



[Sat Mar 22 14:35:58 2014] [error] [client ::1] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\\wamp\\www\\testmysql.php on line 2

This is a similiar issue again see this part of the message ([client ::1] )

edit your httpd.conf file ( use the wampmanager menus to open it )

Find this section
#   onlineoffline tag - don't remove
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1

And chnage it to
#   onlineoffline tag - don't remove
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1 ::1 localhost



[Sat Mar 22 14:47:43 2014] [error] [client 192.168.1.59] File does not exist: C:/wamp/www/jsonrpc

This line makes me think you have chnaged your DocumentRoot parameter in httpd.conf but you have not yet created the new folder.
Changing DocumentRoot is rarely necessary. For multiple sites setting up Virtual Hosts is a much better idea.
I ican supply a HOWTO if you want to go this route.



Ok lets leave it at that, try those fixes and then let me know whta is left. You can remove duplicate errors, one or two of the same error is enough.

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.