Issue: Access of \phpmyadmin is denied to root user (and others)
Fixed in upcoming release.
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:
- 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
Edit file (via Notepad):
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:
- Make sure this line is present:
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:
Issue: LocalDNS does not work, and/or Hosts file gets overwritten
Reported. Could depend on OS, antivirus software, and environment.
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.
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.
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 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
Fixed in upcoming release.
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_admin_flag opcache.enable Off
It also does not matter if the phpmyadmin file paths are excluded via OPcache’s blacklist file:
PHP, OPcache Extension, and/or Apache bug.
Comment out and do not use “php_admin_flag opcache.enable Off” at all (not in websites’ VirtualHost files nor in Apache configuration files).
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
PHP 5.5.11 (via mod_php)