WampServer

I am trying to install Wordpress on my home computer using localhost for local development and learning purposes.
So far I have downloaded and installed wampserver 2.5, the 64bit version from source forge on my windows home 64bit premium machine.
My understanding is that this is a complete download with no need to download PHP or any extras etc.
I have removed IIS7. Skype has been shifted from port 80.
I can access my "localhost" page on port 80 no problem.
If I try to call phpmyadmin from wampserver I get the 500 internal server error.
I need to be able to access phpmyadmin at this point to create a data base to install Wordpress files before I can proceed any further.
Any ideas on how to overcome this please people?
I am a complete newbie to using wampserver, php and Wordpress. I am used to working with dreamweaver CS5 and visual studio so I could be missing something absolutely basic.

Hi John,

Can you answer these questions and work through the basic trouble shooting suggested here [forum.wampserver.com]

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

Also can you check that you have al the required MSVC Runtime libraries loaded.

See here for help [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(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 RiggsFolly,
Sorry for the delay but this is the first day I've had time to get to the fault finding.
I can currently answer:

1) Win Version 7, home premium, 64 bit, version 6.1

2) Wampserver version 64, version 2.5, 64bit

3) Apache version 2.49

4) PHP version 5.5.12

5) MySQL version 5.6.17

6) The icon is green

a - Apache error log's todays entries are:
"[Sat Jan 17 15:01:33.204926 2015] [core:warn] [pid 9464:tid 264] AH00098: pid file C:/wamp/bin/apache/apache2.4.9/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Jan 17 15:01:34.493000 2015] [mpm_winnt:notice] [pid 9464:tid 264] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Sat Jan 17 15:01:34.493000 2015] [mpm_winnt:notice] [pid 9464:tid 264] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Sat Jan 17 15:01:34.493000 2015] [core:notice] [pid 9464:tid 264] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d C:/wamp/bin/apache/apache2.4.9'
[Sat Jan 17 15:01:34.498000 2015] [mpm_winnt:notice] [pid 9464:tid 264] AH00418: Parent: Created child process 6260
[Sat Jan 17 15:01:35.065033 2015] [mpm_winnt:notice] [pid 6260:tid 240] AH00354: Child: Starting 64 worker threads."

Apache access log's todays entries are:
"127.0.0.1 - - [17/Jan/2015:15:04:15 +1300] "GET / HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:04:16 +1300] "GET /index.php?img=gifLogo HTTP/1.1" 200 4549
127.0.0.1 - - [17/Jan/2015:15:04:16 +1300] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
127.0.0.1 - - [17/Jan/2015:15:04:16 +1300] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
127.0.0.1 - - [17/Jan/2015:15:04:16 +1300] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [17/Jan/2015:15:04:16 +1300] "GET /index.php?img=favicon HTTP/1.1" 200 1429
127.0.0.1 - - [17/Jan/2015:15:04:42 +1300] "GET /?lang=fr HTTP/1.1" 200 4556
127.0.0.1 - - [17/Jan/2015:15:04:56 +1300] "GET /phpmyadmin/ HTTP/1.1" 500 -
127.0.0.1 - - [17/Jan/2015:15:05:13 +1300] "GET /phpmyadmin/ HTTP/1.1" 500 -
127.0.0.1 - - [17/Jan/2015:15:17:11 +1300] "GET / HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:17:18 +1300] "GET /?lang=fr HTTP/1.1" 200 4556
127.0.0.1 - - [17/Jan/2015:15:17:30 +1300] "GET /phpmyadmin/ HTTP/1.1" 500 -
127.0.0.1 - - [17/Jan/2015:15:17:38 +1300] "GET /phpsysinfo/ HTTP/1.1" 200 1688
127.0.0.1 - - [17/Jan/2015:15:17:38 +1300] "GET /phpsysinfo/templates/phpsysinfo.css HTTP/1.1" 200 2405
127.0.0.1 - - [17/Jan/2015:15:17:38 +1300] "GET /phpsysinfo/gfx/html.gif HTTP/1.1" 200 94
127.0.0.1 - - [17/Jan/2015:15:17:38 +1300] "GET /phpsysinfo/index.php?disp=dynamic HTTP/1.1" 200 359
127.0.0.1 - - [17/Jan/2015:15:17:38 +1300] "GET /favicon.ico HTTP/1.1" 200 202575
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/ HTTP/1.1" 302 -
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/login.php HTTP/1.1" 200 1179
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/css/print.css?ver=1_3_3 HTTP/1.1" 200 478
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/css/common.css?ver=1_3_3 HTTP/1.1" 200 13378
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/js/movement.js?ver=1_3_3 HTTP/1.1" 200 4739
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/css/navigation.css?ver=1_3_3 HTTP/1.1" 200 1578
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/js/mootools-1.2-core.js?ver=1_3_3 HTTP/1.1" 200 45020
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/themes/bittersweet/css/main.css?ver=1_3_3 HTTP/1.1" 200 2657
127.0.0.1 - - [17/Jan/2015:15:18:06 +1300] "GET /sqlbuddy/js/helpers.js?ver=1_3_3 HTTP/1.1" 200 34324
127.0.0.1 - - [17/Jan/2015:15:18:07 +1300] "GET /sqlbuddy/images/button.png HTTP/1.1" 200 428
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/ HTTP/1.1" 200 12838
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/styles/style.css HTTP/1.1" 200 2715
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/js/jquery.blockUI.js HTTP/1.1" 200 15858
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/js/sprintf.js HTTP/1.1" 200 2445
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/js/jquery.tablesorter.js HTTP/1.1" 200 23927
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/js/jquery.js HTTP/1.1" 200 29846
127.0.0.1 - - [17/Jan/2015:15:18:12 +1300] "GET /webgrind/js/jquery.selectboxes.js HTTP/1.1" 200 12113
127.0.0.1 - - [17/Jan/2015:15:18:13 +1300] "GET /webgrind/img/reload.png HTTP/1.1" 200 354
127.0.0.1 - - [17/Jan/2015:15:18:13 +1300] "GET /webgrind/img/head.png HTTP/1.1" 200 311
127.0.0.1 - - [17/Jan/2015:15:18:13 +1300] "GET /webgrind/img/bg.gif HTTP/1.1" 200 64
127.0.0.1 - - [17/Jan/2015:15:18:13 +1300] "GET /webgrind/index.php?op=version_info HTTP/1.1" 200 107
127.0.0.1 - - [17/Jan/2015:15:47:04 +1300] "GET / HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:47:10 +1300] "GET /?lang=fr HTTP/1.1" 200 4556
127.0.0.1 - - [17/Jan/2015:15:47:28 +1300] "GET /?lang=en HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:47:37 +1300] "GET /?lang=en HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:48:00 +1300] "GET / HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:49:28 +1300] "GET / HTTP/1.1" 200 4542
127.0.0.1 - - [17/Jan/2015:15:49:29 +1300] "GET /index.php?img=favicon HTTP/1.1" 200 1429
127.0.0.1 - - [17/Jan/2015:15:49:29 +1300] "GET /index.php?img=gifLogo HTTP/1.1" 200 4549
127.0.0.1 - - [17/Jan/2015:15:49:29 +1300] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
127.0.0.1 - - [17/Jan/2015:15:49:29 +1300] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
127.0.0.1 - - [17/Jan/2015:15:49:29 +1300] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [17/Jan/2015:15:50:29 +1300] "-" 408 -
127.0.0.1 - - [17/Jan/2015:15:50:44 +1300] "GET /phpmyadmin/ HTTP/1.1" 500 -"

b- MySQL log did not exist or "could not be found" and so I created a blank one in notepad now MySQL log shows an empty file.

c- PHP error log did not exist or "could not be found" and so I created a blank one in notepad now MySQL log shows an empty file.

d- there were no errors showing for either apache or MySQL in eventvwr.exe.

7- the active lines in C:\Windows\System32\drivers\etc\hosts are:

127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost

8) I can access local host page at: [localhost] or at [127.0.0.1]

9) I do not have access to phpmyadmin. at [localhost]

10) The error message is:
HTTP 500 Internal Server Error.

on the page is displayed:

"The website cannot display the page

HTTP 500

Most likely causes:
•The website is under maintenance.
•The website has a programming error.

What you can try:

Retype the address.

Go back to the previous page.

More information More information"

11) My antivirus/firewall app is Norton 360.

12) The complete path is: C:\wamp\wampmanager.exe which starts it in c:\wamp

I will now try to see if the required Microsoft Visual C runtime libraries are installed.

Re this answer:

b- MySQL log did not exist or "could not be found" and so I created a blank one in notepad now MySQL log shows an empty file.


If the wampmanager icon is GREEN as you say but the mysql error log is empty then I think you have another MySQL server running on your system !!!!!! Or maybe a my.ini file somewhere that is getting picked up instead of the correct one.

The MySQL error log will always contain something as it shows startup messages.

First do a search for `my.ini` and `my.cnf` if you find any outside of the \wamp\bin\mysql\... folder structure, delete or rename them.

Also check that you do not have another MySQL Server running on your system.
Check by running services.exe and look at which services are running. WAMPServers MYSQL is called `wampmysald` or `wampmysqld64` ( if you are running wampserver64bit)

If you find a service, probably called MYSQL then you have another MySQL Server running. If this si the case you had better work out why, it does come embeded in some other software.

If you are unsure what to do tell me what you think installed the other MySQL Server.

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

OK a couple of steps forward but still not there yet.
Several of the MSVC ++ runtimes were corrupted somehow They have now been repaired.

Today I found I had an old version of PHP installed. That has been uninstalled with revo uninstaller and now I get past the 500 internal server error to a new error.

This is:
" Welcome to phpMyAdmin

Error

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

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Retry to connect "

PHP error log today now gives me:
"[19-Jan-2015 02:18:46 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

[19-Jan-2015 02:18:47 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - %1 is not a valid Win32 application.

in Unknown on line 0

[19-Jan-2015 02:18:54 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

[19-Jan-2015 02:18:54 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - %1 is not a valid Win32 application.

in Unknown on line 0"


I am now checking to see if an old version of MYSQL is installed. I think there might be. 5.1 to be exact.
It is in C:\Program Files\MySQL\MySQL Server 5.1\bin
There is also a command line version and a MySQL Server Instance Config Wizard installed from 2010. It mightn't also belong.
I won't uninstall these yet just rename the older version and see what happens to begin with.

Nope that didn't work.
When I try to bring up the SQL consul manually It asks for a password but I haven't set one yet: See the error message
"#1045 - Access denied for user 'root'@'localhost' (using password: NO)"
So no password has been set.
????

Morning John,

Ok, we are getting there.

The errors in the PHP Error log can be cleared by doing this :-

Start WAMPServer
Using the menus do -

left click wampmanager -> Apache -> Version -> (now click the apache version number 2.4.9)

This will re-create the missing SYMLINKS in the apache2.4.9/bin folder, it will also restart Apache for you.

-----------------------

RE: The other MySQL Server running on your system:
The simple way to deal with this, until you have the courage to uninstall it is to disable the service. To do that do the following.


Run the services snapin, Click Start -> Control Panel -> Administrative Tools -> Services

In the services dialog, find the MYSQL service and select it with a click

There should now be a 'Stop' clickable link, click this to stop that MySQL.

right click the MYSQL line and click on 'Properties' on the menu that appears
Change the 'Startup Type' from Automatic to Disabled


Dont worry, the WAMPServer services are called 'wampapache` and wampmysql' respectively, so you wont be effecting the WAMPServer version of MySQL.


Then try restarting all services from the wampmanager menu.


Most installs of MySQL assume that, as they are servers, they should be started 'Automaticlly' at boot time. This will stop the other MySQL from starting at all, until you change the startup type again, or uninstall that version of MySQL.

The problem of course when 2 default MySQL Servers are runnig on the same system is that other software communicates with MySQL via a TCP port, 3306 in fact. If you have 2 bits of software both trying to LISTEN on the same port, the second one to allowcate that port, will fail. As the other MySQL service is started Automatically at boot and WAMPServers is started manually but us starting WAMPServer the WAMPServer instance always attempt to allocate the port second and will get the request rejected.
That of course means when we try to communicate with MySQL we are actually talking to the other instance where in your case there is a password set on the 'root' user account.

---------------------------------------------------------------------------------------------
(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, Thank you, Thank you RiggsFolly.
That has solved it.

I'll figure out later what app is using the original SQL version.
I should perhaps have done this with the original PHP as well rather uninstall it but I guess at sometime I'll find out what's now not working as a result of removing the original install.

Now I can proceed with the rest of my Wordpress local installation.

Actually as an aside now I have wampserver working I'm wondering whether I will proceed with Wordpress to build my website locally or whether or go with one of the other similar such as Drupal or Joomla.

The end plan is to remove my website from my current website host, get a static IP from my current ISP and run it from here on my own server.

This is a project that will keep me out of mischief for sometime I think.
But thank you very much for helping me move past the roadblock I had getting to this point.

John Lane.



Edited 1 time(s). Last edit at 01/20/2015 09:47AM by Johnlnz.

Gald to be of assistance.

However I will make this small warning.


WAMPServer is intended to be a developer tool sitting on a developers workstation. There is no reason why you cannot make use of it as a LIVE internet facing web server, afterall it is full strength Apache/MySQL and PHP

BUT!

It is a developer tool, it has not been hardened against the bad guys out there, especially in relation to Apache. There are many security based modules you may need to research before allowing www access to your server.

Also you need to know quite a bit about windows in order to run it in a secure environment, and thats windows server and not windows desktop OS.

The desktop OS will not service the requirements of a internet facing web server for many reasons, not least of which is that the Windows Desktop OS will not support more than about 10-20 external connections. So you would not be able to server an even vaguely busy site.

Anyway, just a small warning.

---------------------------------------------------------------------------------------------
(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 for the friendly warning RiggsFolly,

Yes I have a lot of research to do about both servers and apps such as Wordpress etc..

While my OS experimenting and programming days and working with a number of different programming languages (Basic, C++, Pascal, assembler and even Fortran) to develop some individual apps stretch all the way back through GUIs to DOS and even back to the days of tape based machines such as the ZX81 and the Z80 I know next to nothing about servers and I have not been active in the industry even in a hobby capacity for about 22 years now.

The only work I have ever done on the web as such was to use Microsoft Visual Studio to put together a full site for someone else and Adobe Dreamweaver CS5 to put together the top page (page holder only) of my own site recently on my current host. Both of these were just done in a semi hobby capacity.

Since I have now semi-retired from my main income producing businesses I have time to do some more semi hobby level development work. Thus my decision to now learn about using the likes of Wordpress and other similar Content Management Systems etc .

I think taking my own website and redeveloping the top page and the stuff behind it (that is there but is not visible) on wampserver locally then serving it from a separate machine from here is a good way to start.

As well as it will save me money in the long run. LOL.

John L.

P.S. Another experimental hobby years ago of mine (many years ago now) was in the area of developing both the electronics of and apps for interfacing my ham rig to various computers of mine over the years so I have a reasonable hobby level knowledge of the electronics of computers as well.



Edited 2 time(s). Last edit at 01/20/2015 10:48PM by Johnlnz.