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.

Options: ReplyQuote
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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
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.

Options: ReplyQuote


Sorry, only registered users may post in this forum.