WampServer

I have just installed the latest version of WampServer on a Windows 10 pro 64bit PC.
All servers are showing green, installed wordpress and /localhost/wordpress/ launches the configuration page. but /localhost/phpmyadmin/ loads to the login screen but will not go any further. with both user and password left blank it just recycles back to the login page.

Using user 'root' with blank password produce error message:
"#2002- An attempt was made to access a socket in a way forbidden by its access permissions. <br/>The server is not responding ( or the local server's socket is not correctly configured)."

Have tried editing the php config file and resetting servers as suggested on the web but no solution so reset to original. also checket the hosts file but all seems as should be.
Everything seems to have loaded correctly except I am unable to access the database set up needed for wordpress.
Any ideas as to a solution please.
an earlier version was running under windows 7 but was disabled on upgrading to windows 10. I unilstalled any older versions before any new installs.

additional notes:
version wampserver 3.0.4
apache version 2.4.18
PHP version 4.5.5.1
MySQL version 5.7.11
all error logs clear
windows event viewer application errors none
can access Localhost
cannot access phpMyAdmin beyond log in page
Have removed the # from hosts file
127.0.0.1 localhost
and
::1 localhost
the php config.inc file has:
$cfg['Servers'][$i]['auth_type'] = 'cookie'; should this be changed to = 'config';
looking at an old php config.inc file noticed that connection type is missing from the current file

$cfg['Servers'][$i]['connect_type'] = 'tcp'; is this needed?

as far as I can see with my limited knowhow every thing looks normal but still cannot access the phpMyAdmin panel.

Hi,

Try :
Wampmanager Tray Icon -> MySQL -> Mysql Console
It will be asked password: As there is no password after wampserver installation just hit Enter, you must have a command windows like this :

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Launch localhost (Homepage of Wampserver) then in the address bar of the browser type :

'http://localhost/test_sockets.php'

the result must be :
Socket IPv4 supported

Socket IPv6 supported

What is the content of C:\Windows\System32\drivers\etc\hosts ?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi,

You must not modify the file wamp\apps\phpmyadmin4.x.y\config.inc.php that must be :

<?php

/* Servers configuration */
$i = 0;

$cfg['blowfish_secret'] = 'h]C+{nqW$omNoTIkCwC$%z-LTcy%p6_j$|$Wv[mwngi~|e'; //What you want

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Local Databases';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

// Allow connection without password
$cfg['Servers'][$i]['AllowNoPassword'] = true;

// Suppress Warning about pmadb tables
$cfg['PmaNoRelation_DisableWarning'] = true;

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
/* End of servers configuration */

?>

> $cfg['Servers'][$i]['auth_type'] = 'cookie'; should this be changed to = 'config';
When you make a change, whatever it is, you MUST know the implications, which is not the case, because if you put config, you MUST also fill in the user and password.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Wampmanager Tray Icon -> MySQL -> Mysql Console
asks for password hit return it thinks for awhile then shuts down

The hosts file:
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
::1 localhost

the last two lines were originally commented with a #

the config.inc.php file is
<?php

/* Servers configuration */
$i = 0;

$cfg['blowfish_secret'] = 'h]C+{nqW$omNoTIkCwC$%z-LTcy%p6_j$|$Wv[mwngi~|e'; //What you want

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Local Databases';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

// Hidden databases in PhpMyAdmin left panel
//$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|sys)';

// Allow connection without password
$cfg['Servers'][$i]['AllowNoPassword'] = true;

// Suppress Warning about pmadb tables
$cfg['PmaNoRelation_DisableWarning'] = true;

// To have PRIMARY & INDEX in table structure export
//$cfg['Export']['sql_drop_table'] = true;
//$cfg['Export']['sql_if_not_exists'] = true;

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
/* End of servers configuration */

While waiting and reading your forum I tried a reinstall with Wampserver 3.0.6 x64
after making sure that all the vc++ packages were up to date using your tool check_vcredist

some were missing so updated and second check reported all packages needed were installed.

The reinstall did not cure the problem and it remains as described.

is there another way to test the sockets?

I forgot
a second error message when accessing the phpMyAdmin pops up

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

also the
'http://localhost/test_sockets.php' gives a HTTP 404 Not Found message

Hi,

I think there is another mysql running or not the good one.

- Wampmanager Tray Icon -> MySQL -> Service -> Stop service
- Wampmanager Tray Icon -> MySQL -> Service -> Remove Service
- Wampmanager Tray Icon -> MySQL -> Service -> Install Service
- Wampmanager Tray Icon -> MySQL -> Service -> Start Service

- Right-Click Wampmanager Tray Icon -> Tools -> Test port 3306

For Wampserver 3.0.6 64 bits the answer should be like this :

***** Test which uses port 3306 *****

===== Tested by command netstat filtered on port 3306 =====


Test for TCP
Your port 3306 is used by a processus with PID = 6096
The processus of PID 6096 is 'mysqld.exe' Session: Services
The service of PID 6096 for 'mysqld.exe' is 'wampmysqld64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 3306 is used by a processus with PID = 6096
The processus of PID 6096 is 'mysqld.exe' Session: Services
The service of PID 6096 for 'mysqld.exe' is 'wampmysqld64'
This service is from Wampserver - It is correct

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

stopped services, Removed service , installed service and restarted

Test on port 3306 produced

***** Test which uses port 3306 *****

===== Tested by command netstat filtered on port 3306 =====


Test for TCP
Your port 3306 is used by a processus with PID = 5868
The processus of PID 5868 is 'mysqld.exe' Session: Services
The service of PID 5868 for 'mysqld.exe' is 'wampmysqld64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 3306 is used by a processus with PID = 5868
The processus of PID 5868 is 'mysqld.exe' Session: Services
The service of PID 5868 for 'mysqld.exe' is 'wampmysqld64'
This service is from Wampserver - It is correct

Hi,

That is correct!
May be you have another mysql or an old my.ini file.

See TROUBLESHOOTING TIPS, all points but specially points 07, 08, 11, 12, 13

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

have run a search for all my.ini files the only instance is in the wamp64 folder.

have not run a search for any other instances of mysql trying to run and will try the troubleshooting tips again I may have missed one.. I will check Monday when I get back to the computer.

have a good weekend

I have rerun searches for my.ini
only one instance found in the wamp directory

I have removed the internet information service from add remove windows components.

ran a search for other phpmyadmin again only the version in wamp found

I ran a search for other instances of MySQL and found it listed under an old version of adobi bridge cs3.

I uninstalled and uninstalled all old versions of photoshop and bridge just leaving version cs6.

re run the search for MySQL and now only listed under wamp.

restarted servers but phpmyadmin has the same conditions

will do a second system restart just in case and will update this post.

restart had no effect

the log in using root; error is

At the top
#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).

when saved as a word document this line shows up

<div class="error"><img src="themes/dot.gif" title="" alt="" class="icon ic_s_error" /> Javascript must be enabled past this point!</div>




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