WampServer

Please help:

Screen shots: [1drv.ms], httpx://1drv.ms/1AIRcjW

I used wamp2.0 for quite a while. Yesterday, I uninstalled it and download the
wampserver2.5-Apache-2.4.9-Mysql-5.6.17-php5.5.12-64b.exe
on my dell XPS with window 7 professional 64bit laptop.

After installation, I started it from the menu. The wamp icon turned green. The Tools/phpmyadmin was working. Then I exit WAMPSERVER.

When I tried strat WAMPSERVER again, it never come back green.
- It is always yellow:
- the Apache "Start/Resume Service" is grey most of the time. Can be restarted by "Restart Service". However it will back to grey couple of minutes later.
- the MySQL "Start/Resume Service" is always green. However, when I tried MySQL console and for "Enter password", I just push ENTER, I came across error message "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- I can get to the local host page: httpx://localhost/, but Tools/phpmyadmin is NOT working with error message saying:
***
MySQL said: #2002 - No connection could be made because the target machine actively refused it.
The server is not responding (or the local server's socket is not correctly configured).
***
- Tools/phpinfo() is working: httpx://localhost/?phpinfo=1
- Your Projects/* is not working. Seems it directed to wrong address. For example, I have a folder under www called three.js.org. Then clicking on "three.js.org" will open "httpx://three.js.org/" instead of httpx://localhost/three.js.org/". The error message says
***
Server not found
Firefox can't find the server at three.js.org.
***
- under Your Aliases, I can get to:
-- httpx://localhost/sqlbuddy/login.php
-- httpx://localhost/webgrind/
-- httpx://localhost/phpsysinfo/index.php?disp=dynamic
Access denied for httpx://localhost/phpmyadmin/.

Note: the httpx is to stop system translate the address to [localhost].

Hi Flying,

First thanks for such a comprehensive description of you issue. It made it quite easy to see what the problem is.

The problem is that the MySQL service is not starting. Page 2 of your PPT, if the "Start/Resume Service" menu is Green then the service is not started, as its not started that menu is green saying that you can use it to start the service.
All the other errors of course relate to no MySQL Server being there to connect to.

So why is this :

The first thing to do is look at the MySQL error log

wampmanager -> MySQL -> Mysql log

This should open up the error log in notepad. What does it tell you?

If that file is empty, or not now getting added to when you try to restart MySQL then the problem with MySQL is happening before it can open its error log and you need to look in the Windows Event Viewer as messages get written here even before the error log is opened.

To view it do :

- Windows Key + R to launch the run dialog then enter eventvwr.exe and press the OK button
- - On the left side of the windows click 'Windows Logs -> Applications'
- - Look for the name 'MYSQL' in the Source column which have an error symbol in the first column.

If the error message is not obvious please copy/paste the COMPLETE error message here so we can see what the problem might be.

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

Thank you, RiggsFolly. I did what you instructed. I have updated the screen shots too.

Opening MySQL log, the message window says "cannot find the c:\wamp\logs\mysql.log file." Seems MySQL got problem even before it starts.

Checking the Windows Event Viewer, I found multiple rows with Source = MySQL and Level = Error. Here is the details of the first one:

- <Event xmlns="[schemas.microsoft.com];
- <System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2015-02-25T15:27:45.000000000Z" />
<EventRecordID>93247</EventRecordID>
<Channel>Application</Channel>
<Computer>Jack-PC</Computer>
<Security />
</System>
- <EventData>
<Data>Aborting</Data>
</EventData>
</Event>

Thanks...

Can you have a look at the others as well to see if any may give an error message that is a little more meaningful than this one.

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

Thanks much. I should have done. Thought they are the same but they are different. There is more information.

The second one:

- <Event xmlns="[schemas.microsoft.com];
- <System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2015-02-25T15:27:45.000000000Z" />
<EventRecordID>93243</EventRecordID>
<Channel>Application</Channel>
<Computer>Jack-PC</Computer>
<Security />
</System>
- <EventData>
<Data>InnoDB: Tablespace open failed for '"mysql"."slave_worker_info"', ignored.</Data>
</EventData>
</Event>

The third one:

- <Event xmlns="[schemas.microsoft.com];
- <System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2015-02-25T15:27:45.000000000Z" />
<EventRecordID>93242</EventRecordID>
<Channel>Application</Channel>
<Computer>Jack-PC</Computer>
<Security />
</System>
- <EventData>
<Data>InnoDB: Could not find a valid tablespace file for 'mysql/slave_worker_info'. See [dev.mysql.com] for how to resolve the issue.</Data>
</EventData>
</Event>

The other ones just repeat these two errors.

Did you copy some old databases into the new mysql folder ?

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

Do you mean copy some files to folder: C:\wamp\bin\mysql\mysql5.6.17? No, I did not.

When I uninstalled the wamp2.0, there are some folder/files left in the folder "wamp" and they can't be deleted completely if I remember correctly. I tried my best to delete all things except the www folder which actually I changed its name to wwwx during installation. So they may be some leftover in the folder "WAMP" including the possibility of have some files in some folder for mySQL.

Havn't said that, I tried to install the new WAMP 2.5 to a new folder other than "WAMP", for example, WAMP2.5. But I still have the problems. Sometimes, it was even worse - I can't get to the localhost page.

I hope you could help find a solution.

Thanks...

You should never install over an existing folder.

See this sticky post [forum.wampserver.com] for how to install a new version

---------------------------------------------------------------------------------------------
(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 tried to install the wamp to a new folder, i.e., WAMP2.5 but it did not work. So I thought this is not the problem.

Upon your post, this time I deleted all existing wamp folders and reinstalled. Now it is working, partially.

The icon is green, both apache and mySQL is working. I can access phpmyadmin.
However, the loading of Your Projects still got same problems:

For example, I have a folder under www called three.js.org. Then clicking on folder "three.js.org" under "Your Projects" at localhost will open "httpx://three.js.org/" instead of httpx://localhost/three.js.org/". The error message says
***
Server not found
Firefox can't find the server at three.js.org.

the php.error.log says:

[26-Feb-2015 04:16:35 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_intl.dll' - The specified module could not be found.

in Unknown on line 0

In the event viewer, I did not see any error for source = mySQL or php though there are a few for .NET---.

how can I fix it? Thanks...

All problems solved. Thanks...