Cannot log in via phpMyAdmin
Posted by: ooma (---.ip.adsl.co.za)
Date: April 12, 2017 05:15PM

Running-
Windows 10, 64bit
Wampserver 3.0.6 64 bit; applied update 3.0.8
Apache 2.4.23
PHP 5.6.25
MySQL 5.7.14
Wampserver icon is green (local server - All services running)
Have access to localhost. No errors at the bottom of the page
Have access to phpMyAdmin
Installtion path c:\wamp64

This a clean install of wampserver. Installation done as administrator.
Neither IIS nor Skype is running.

The etc\hosts was edited to uncomment the following 2 lines-
127.0.0.1 localhost
::1 localhost

Error on trying to login in to phpMyAdmin using 'root' without password is

#2002 - An attempt was made to access a socket in a way forbidden by its access permissions. — The server is not responding (or the local server's socket is not correctly configured).

I can run a simple php scripts without problems.

When I try to connect to the database using mysqli_connect I get the following-
Warning: mysqli_connect(): (HY000/2002): An attempt was made to access a socket in a way forbidden by its access permissions. in C:\wamp64\www\Unit4\MySiteMysql.php on line 14


I can connect to MySQL using the command line console.

I checked the ports -
C:\WINDOWS\system32>netstat -ao|findstr 3306
TCP 0.0.0.0:3306 LAPTOP-JVP46PPC:0 LISTENING 8288
TCP [::]:3306 LAPTOP-JVP46PPC:0 LISTENING 8288
Process 8288 is used by wampsqld64

C:\WINDOWS\system32>netstat -ao|findstr 80
TCP 0.0.0.0:80 LAPTOP-JVP46PPC:0 LISTENING 9568
Process 9568 is used by wampapache64

I don't know what to check with McAfee. How do I turn it off?

Any assistance to get passed this will be greatly appreciated.

Re: Cannot log in via phpMyAdmin
Posted by: RiggsFolly (Moderator)
Date: April 13, 2017 10:46AM

Hi

It sounds like you network drivers have got into a bit of a mess.

Stop WAMPServer and then

Open a command prompt as Administrator

Run

netsh winsock reset
netsh winsock reset catalog
netsh int ip reset reset.log
netsh int ipv4 reset reset.log
netsh int ipv6 reset reset.log
ipconfig /flushdns

Reboot if necessary


Start WAMPServer and try to access phpMyAdmin as before

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

Re: Cannot log in via phpMyAdmin
Posted by: ooma (---.ip.adsl.co.za)
Date: April 18, 2017 09:53AM

Ran all the specified steps. Still cannot log in using phpMyAdmin. Error at the bottom is -

mysqli_real_connect(): (HY000/2002): An attempt was made to access a socket in a way forbidden by its access permissions.

Sorry, only registered users may post in this forum.