WampDeveloper 5 Known Issues and Solutions

v5.0.2.1

Issue: Access of \phpmyadmin is denied to root user (and others)

Status

Fixed in upcoming release.

Effect

When accessing phpmyadmin by using the “phpmyadmin” button in WampDeveloper’s System Tab, or using this URL: http://localhost/phpmyadmin, user ‘root’ is not able to login.

Opposite to the above, this URL does work:
http://127.0.0.1/phpmyadmin

Cause

  • 1) “localhost” is getting resolved to IPv6 “::1″ instead of IPv4 “127.0.0.1″ (due to the Windows Hosts file entries).
  • 2) phpmyadmin’s configuration file config.inc.php is missing an access entry for the corresponding MySQL “root@::1″ account.

It’s possible that the installer was not able to update the Windows Hosts file, and/or Windows Defender (or some other security app) was able to undo the changes.

And if IPv6 is enabled on your system, and “localhost” get’s resolved to the IPv6 loopback address “::1″, user “root” will not be able to login via URL: http://localhost/phpmyadmin

Solution

Edit file (via Notepad):
C:\WampDeveloper\Tools\phpMyAdmin\config.inc.php

Add into the “AllowDeny” rules-array this line:

'allow root from ::1',

Also edit the Windows Hosts file (LocalDNS Tab, button: Hosts File) -

  • Remove line:
    ::1 localhost
  • Make sure this line is present:
    127.0.0.1 localhost

Save files. Then close and open your Browser, and you should now be able to login to phpmyadmin with user root.

* If you still have issues after this, try: 1) clearing the Browser’s cache, 2) stopping Apache and MySQL and clearing out the C:\WampDeveloper\Temp\ folder of all files (but don’t delete the sub-folders), and 3) rebooting/restarting the system.

Exclude the Windows Hosts file in Windows Defender

*If you are also going to use the provided older phpmyadmin version that’s compatible with the Legacy Apache 2.0 and PHP 4.4 channel, it’s not possible to apply part of this fix due to Apache lacking IPv6 support and the IPv6 syntax (“::1″) being unknown to Apache and/or phpmyadmin. So only the Host file edit is needed. Just as a note, if it was possible to use IPv6 on that channel, these files would need to be updated:
Tools\phpmyadmin.php4\config.inc.php
Tools\phpmyadmin.php4\.htaccess
Config\Apache\extra\wampd-phpmyadmin.conf

Issue: LocalDNS does not work, and/or Hosts file gets overwritten

Status

Reported. Could depend on OS, antivirus software, and environment.

Effect

a) On WampDeveloper installation, the entire Windows Hosts file is emptied, or only contains 1 or 2 entries.

b) On website creation or LocalDNS changes, domain-names do not work.

Cause

Antivirus software such as BitDefender (and Windows Defender) block WampDeveloper from making edits to the Hosts file, and/or attempt to restore this file when changes are detected.

Solution

Exclude the process C:\WampDeveloper\wampdeveloper.exe and the folder C:\WampDeveloper\ in the anti-virus software’s settings.

Then open Windows Hosts file (LocalDNS Tab, click button: Hosts file), and add at least these entries in:

127.0.0.1 localhost

127.0.0.1 ServerStatus stat.apache.local
127.0.0.1 ServerInfo info.apache.local
127.0.0.1 ServerHost host.apache.local

127.0.0.1 DefaultWebsite website

127.0.0.1 www.example.com example.com

Issue: PHP’s OPcache crashes Apache on some phpMyAdmin URLs

Status

Fixed in upcoming release.

Effect

Having PHP’s OPcache extension globally enabled AND having “php_admin_flag opcache.enable Off” in either the website’s VirtualHost file or in the configuration of Config\extra\wampd-phpmyadmin.conf will cause Apache to crash after several \phpmyadmin tabs are clicked in succession.

(php.ini)

zend_extension="C:\WampDeveloper\Components\Php\ext\php_opcache.dll"
opcache.enable=1

(C:\WampDeveloper\Config\Apache\extra\wampd-phpmyadmin.conf)
(C:\WampDeveloper\Vhosts\localhost.http.vh.conf)

php_admin_flag opcache.enable Off

URL:

http://localhost/phpmyadmin

It also does not matter if the phpmyadmin file paths are excluded via OPcache’s blacklist file:

(php.ini)

opcache.blacklist_filename="C:\WampDeveloper\Config\Php\opcache.blacklist.txt"

(C:\WampDeveloper\Config\Php\opcache.blacklist.txt)

C:\WampDeveloper\Tools\phpMyAdmin\
C:\WampDeveloper\Tools\phpMyAdmin.php4\

Cause

PHP, OPcache Extension, and/or Apache bug.

Solution

Comment out and do not use “php_admin_flag opcache.enable Off” at all, not in websites’ VirtualHost files nor in any Apache configuration files.

Edit file -
C:\WampDeveloper\Config\Apache\extra\wampd-phpmyadmin.conf

Remove line -

php_admin_flag opcache.enable Off

Also do the same in these files, if they exist -
C:\WampDeveloper\Vhosts\localhost.http.vh.conf
C:\WampDeveloper\Vhosts\localhost.ssl.vh.conf

And perform the same edit in all your websites’ VirtualHost files -
C:\WampDeveloper\Vhosts\primary.domain.name.http.vh.conf
C:\WampDeveloper\Vhosts\primary.domain.name.ssl.vh.conf

If needed, exclude phpmyadmin (and other) file paths via OPcache’s blacklist… Or don’t disable the caching of phpmyadmin if no opcode cache issues are present with used PHP, OPcache Extension, and phpmyadmin versions.

WAMP Component Versions

Apache 2.4.9
PHP 5.5.11 (via mod_php)
phpMyAdmin 4.1.8.0

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>