WampServer

Version of Operating system? - Version of Windows Vista SP2 32 bit
Version of Wamp Server installed? - Version 2.5 32 bit
Version of Apache you are running - 2.4.9
Version of MySQL you are running - 5.6.17
Version of PHP you are running - 5.5.12

HOSTS log entries:
# Copyright (c) 1993-2006 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

127.0.0.1 localhost
::1 localhost

127.0.0.1 localhost

WampManager icon is Orange

When I test port 80 from WampManager it shows that port 80 is used by Microsoft IIS 7.0.

There were some occasions the icon does turn green, but the label still reads 'server offline'. When I click on phpmyadmin from WampManager, it gives me a 404 error.

I'm a beginner here and I'm trying to set up the environment to try out some WordPress development.

What is the problem and how do I fix please? Please help. Thank you.



Edited 1 time(s). Last edit at 11/18/2014 12:58AM by vcteo.

The problem is that you have another web server running i.e. IIS

You will have to disable it or stop or uninstall it ( if you are not using it )

These other services can also be included with IIS and may also need to be diabled


Web Deploy 2.0
MS Sql Server Reporting service.
BranchCache ( Windows 8.1 )

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

RiggsFolly Wrote:
-------------------------------------------------------
> The problem is that you have another web server
> running i.e. IIS
>
> You will have to disable it or stop or uninstall
> it ( if you are not using it )
>
> These other services can also be included with IIS
> and may also need to be diabled
>
>
> Web Deploy 2.0
> MS Sql Server Reporting service.
> BranchCache ( Windows 8.1 )

Thanks for the prompt reply. I'll google how to stop the IIS. Just for my learning, where from my description could you tell that IIS was the problem?

The issue is at when I try netstat -a -b (googled it), it keeps giving me the error "The requested operation requires elevation", which is funny because I'm logged into the only account in Windows and I'm an administrator. Trying to google a way to stop all services at port 80.

Quote

Just for my learning, where from my description could you tell that IIS was the problem?

Here in the error message that you copy and pasted

When I test port 80 from WampManager it shows that port 80 is used by Microsoft IIS 7.0.

They that have eyes but will not see

Quote

The issue is at when I try netstat -a -b (googled it), it keeps giving me the error "The requested operation requires elevation", which is funny because I'm logged into the only account in Windows and I'm an administrator.

Well actually since VISTA and UAC there is not Administrator user. You may have the rights to elevate yourself but you are not an administrator.

So to execute these, and other admin privileged commands, do this you need to :-
Launch a command windows by, shift+rightclick over the command windows icon in the start menu and use the 'Run as administrator' menu item.
Then you will have the full admin privileges.

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

Duh...missed the part about IIS thanks! I've disabled IIS and some other stuff and now the icon is green.

But now I have another problem, when I try to login to phpmyadmin, I get this

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

There were no prompts for me to enter password in the first place.

This is from config.inc.php

/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

I didn't set any password in the first place so this is blank
$cfg['Servers'][$i]['password'] = '';

So I followed the steps from here

[dev.mysql.com]

up to this command

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt

I replaced the mysql location to the one in the wamp folder

C:\> C:\wamp\bin\mysqld-nt --init-file=C:\\mysql-init.txt


where I got this error message at the cmd prompt

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt
'c:\wamp\bin\mysqld-nt' is not recognized as an internal or external command, operable program or batch file.

I checked here
C:\wamp\bin\mysql\mysql5.6.17\bin
and I can't find a file called mysqld



Edited 3 time(s). Last edit at 11/18/2014 11:26AM by vcteo.

Are you sure you dont have another MySQL Server running on your system?
WamServers services are called

MySQL = wampmysqld or wampmysqld64
Apache = wampapache

Do you have a service running called MYSQL?

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

RiggsFolly Wrote:
-------------------------------------------------------
> Are you sure you dont have another MySQL Server
> running on your system?
> WamServers services are called
>
> MySQL = wampmysqld or wampmysqld64
> Apache = wampapache
>
> Do you have a service running called MYSQL?


I went to Control Panel -> Administrative Tools -> Services and checked. I only have one MySQL item and I've stopped it as instructed.

I found wampapapache, wampmysqld. Both are currently started. Should I stop them and try the command again?

Also, with all the variant's of commands, which one should I be using?



Edited 1 time(s). Last edit at 11/18/2014 11:31AM by vcteo.

Running 2 MYSQL Server instances is a bit complicated for a beginner, and uses loads of memory for no good reason.
If you can i.e. you have no idea why you have the other MySQL instance I would uninstall it if possible, saving any databases first of course. Did you install MySQL Workbench? There are 2 versions of that, one comes with an instance of MySQL and the other does not. If thats where the other MYSQL came from, uninstall MYSQL WOrkbench and then install the one without its own MYSQL. It will happily use the instance from WAMPServer.

Having stopped the other MYSQL, you should be able to Start the one that came with WAMPServer.

This one does not have a password on the 'root' userid so it should allow phpMyAdmin in with its current settings.




See what I mean about 2 MYSQL instances causing confusion?

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

It works! Thanks for your help Riggs

What worked?

What was the problem?

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

I uninstalled all instances of MySQL, leaving only wampapache and wampmysqld.

Changed this

#$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';

to this

$cfg['Servers'][$i]['auth_type'] = 'cookie';
#$cfg['Servers'][$i]['auth_type'] = 'config';



Edited 1 time(s). Last edit at 11/18/2014 03:32PM by vcteo.