WampServer

1 Windows 11 Home
2 WAMP Version 3.3.7 - 64bit
3 Apache 2.4.62.1
4 PHP 8.3.14
5 MySQL 9.1.0
5a MariaDB 11.5.2
6 WampServer icon - green
7 127.0.0.1 localhost
::1 localhost

127.0.0.1 abelard
::1 abelard

127.0.0.1 magnacp
::1 magnacp

127.0.0.1 sites
::1 sites

8 Localhost displays without problem
8a no error message.
9 phpMyAdmin, I can open log-in page, but
10 "Cannot log in to the MySQL server"
11 Windows Defender firewall, F-Secure antivirus
12 C:/wamp64/
13 There are three domains running on the local server.
[magnacp] (simple, no database usage)displays without problem.
[sites], list of local links, works as expected
[abelard] 'with databases and generally more complex, if not very sophisticated) displays
"This site can’t be reached
"abelard refused to connect."

Because the Wampserver version is not the most recent, I attempted to updatd it to the most recent version:
Renamed current folder to wamp64-old,
Stopped all Services
Removed service - MySQL, Apache
Ran install of downloaded wampserver3.4.0_x64.exe file as Administrator.
"Wampserver 64bit is already installed.
Installation will be cancelled."

Please would you advise me?
Thanking you in advance

Hi,

There is an update for Wampserver 3.4.0, which is the one you should use!

> Cannot log in to the MySQL server
Because you have a password that you need to use.

> F-Secure antivirus
With Windows 11, you absolutely do not need third-party antivirus software!

> 88-170-88-45.subs.proxad.net
Il existe un forum francophone !!

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

Thank you for you reply.

*Because the Wampserver version is not the most recent, I attempted to updatd it to the most recent version:
Renamed current folder to wamp64-old,
Stopped all Services
Removed service - MySQL, Apache
Ran install of downloaded wampserver3.4.0_x64.exe file as Administrator.
"Wampserver 64bit is already installed.
Installation will be cancelled."

**WAMP icon now red:**
**Localhost no longer available**
Thus, cannot access MySQL server page.

Checking State of services in Tools,

State of services:

The service 'wampapache64' is not RUNNING nor STOPPED.
[SC] EnumQueryServicesStatus:OpenService failure(s) 1060 :
The specified service does not exist as an installed service.
********* The service 'wampapache64' does not exist ********

The service 'wampmysqld64' is not RUNNING nor STOPPED.
[SC] EnumQueryServicesStatus:OpenService failure(s) 1060 :
The specified service does not exist as an installed service.
********* The service 'wampmysqld64' does not exist ********

The service 'wampmariadb64' is NOT started
EXIT error code:1067
Help message for error code 1067 is:The process terminated unexpectedly.

WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
'wampmariadb64'
is not started.

all services BINARY_PATH_NAME are OK
all services START_TYPE are OK

*Stopped the third-party antivirus software.

Please would you advise further?
TIA.

> *Because the Wampserver version is not the most recent, I attempted to updatd it to the most recent version:
> Renamed current folder to wamp64-old,

There is absolutely nothing to rename!!!!

You just need to apply the Wampserver 3.4.0 update!

Wampserver update 3.4.0

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

Did you export all of your mySQL databases before uninstalling, and then re-create them?

You cannot simply swap out an old version and replace it with a new version and expect that the databases will be OK

Thank you for your patience.

* Renaming WAMP folder to WAMP-old

I believe I confused two instruction pages "WAMPServer 3 All you need to know" and
"Installing a new release of WAMPServer”.
The second had the line,"Rename your wamp folder to something eg 'wamp_old'. This is your backup!"
My feeble excuse, I have progressive MS which, annoyingly, affects my concentration abilities and following seemingly simple tasks. This has been compounded by cracking a rib with its unexpected and sharp pain if I make an aggravating movement. Or a required one, like standing up.


Is there anyway to resue the situation, or do I remove WAMPsever completely and start from scratch?

*Not exporting all SQL databases

Thank you for Your patience.

See the feeble excuse in reply to Otomatic just above.

I'm really sorry, my rot gets the better of me after a bit. (I feel as capable as I was once, and then reality gives me a sucker punch – sheesh.)

Can I make repairs or do I remove and reinstall WAMP?

If you reinstall (after uninstalling), you will lose your databases.

- Back up the data folder (c:\wamp64\bin\mysql\mysqlx.y.z\data\) of the mySQL version used (or mariaDB if you use it) and make a note of the version number.
- If necessary, back up your own folders (VirtualHost) in c:\wamp64\www\.
- Back up the http-vhosts.conf file.
I think it would be easier to make a copy of c:\wamp64-old.

Rename the wamp64-old folder to its original name and proceed with uninstalling Wampserver.

Install version 3.4.0.

To be continued once everything has been completed.

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

Dear Otomatic

Thank you for your instructions.

Files have been backed up, WAMP has been uninstalled, and version 3.4.0 has been installed.

Please would you advise me further ?

Hi,

- Install the version of MySQL that you were using before.
If this version is not available on https://wampserver.aviatechno.net/, please let me know.

- Launch Wampserver and switch MySQL to this version.
Left-click -> MySQL -> version

- Exit Wampserver

For further explanations, please provide me with the Wampserver installation directory and the MySQL version.

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

Deleted WAMP server.
Installed WAMPserver3.40.
Copied back saved MySQL file.
Tried opening the tray app for WAMPserver – faint orange icon that does not respond to right or to left clicks, so cannot switch MySQL.

In Localhost :
( ! ) Warning: require(../files/apacheloadedmodules.php): Failed to open stream: No such file or directory in C:\wamp64\www\index.php on line 230
Call Stack
#
Time
Memory
Function
Location
1
0.0002
458944
{main}( )
...\index.php:0

( ! ) Fatal error: Uncaught Error: Failed opening required '../files/apacheloadedmodules.php' (include_path='.;C:\php\pear') in C:\wamp64\www\index.php on line 230
( ! ) Error: Failed opening required '../files/apacheloadedmodules.php' (include_path='.;C:\php\pear') in C:\wamp64\www\index.php on line 230
Call Stack
#
Time
Memory
Function
Location
1
0.0002
458944
{main}( )
...\index.php:0

Returning to  [wampserver.aviatechno.net] ,
at the end of the section for MySQL downloads is the following :

Important Reminder: The transfer of databases between different versions of MySQL or MariaDB should be performed by EXPORT / IMPORT of SQL files using phpMyAdmin or a similiar tools of your choice. Do not copy the data folder between different versions of MYSQL or MariaDB. Databases from different versions of MYSQL or MariaDB are VERY unlikely to be compatible! You will also destroy the version of MYSQL or MariaDB that you copied the data folder to.

I cannot access phpMyAdmin in order to EXPORT / IMPORT the MySQL9.1.0 file.

Wampserver installation directory : C:/WAMP64
MySQL version : MySQL 9.1.0

Please would you advise ?

Hi,

> Tried opening the tray app for WAMPserver – faint orange icon

As long as the icon is not green, meaning that the three services have not been started, do not try to do anything! It will not work!

> does not respond to right or to left clicks
It appears that you have a problem with your system.

Using the service manager, see which service is not started: wampapache64, wampmysqld64, or wampmariadb64. Try to start it via the manager. If necessary, note the error message.

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

Thank you for your help.

In services.msc,
wampmysqld64 not "running".
Tried to start.
Error message : Windows could not start the wampmysqld64 service on Local Computer.
Error 2: The system cannot find the file specified.

In the Services Manager, delete the wampmysqld64 service.
This can be done in a command window "as administrator" using the command:
sc delete wampmysqld64

In the command window, use the "cd" commands to navigate to the folder
c:\wamp64\bin\mysql \mysqlx.y.z\bin\
where x.y.z is the MySQL version used by WampServer.
Then type:
mysqld --install-manual wampmysqld64

This will reinstall the MySQL service.

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

In command window, received '[SC] DeleteService SUCCESS'.

Entered 'mysqld --install-manual wampmysqld64'.
This returned

The service already exists.
The current server installed: c:\wamp64\bin\mysql8.4.7\bin\msqld.exe wampmysqld64

Note that the MySQL installed is version 9.1.0.

Thanks again for your help.

I don't understand!
How can a service exist when you just deleted it with the command
sc delete wampmysqld64

After running sc delete wampmysqld64, check in the Service Manager that this service no longer exists.
Note: Do not open the Service Manager before running the sc delete command.

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

Dear Otomatic

Me, I understand less.

In CMD as administrator, ran C:\>sc delete wampmysqld64
The response returned is

... [SC] DeleteService FAILED 1072:

... The specified service has been marked for deletion.

Help! Please.

Hi,

- Restart Windows

Check in the Services Manager that the wampmysqld64 service has disappeared.

In the command window, use the "cd" commands to navigate to the folder
c:\wamp64\bin\mysql \mysqlx.y.z\bin\
where x.y.z is the MySQL version used by WampServer.
Then type:
mysqld --install-manual wampmysqld64

This will reinstall the MySQL service.

Start Wampmanager

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

Thank you for your reply.

I followed your instructions.

However, on starting Wampmanager, the icon in the tray is faintly green and does not repond to clicks from the mouse.
Further, localhost shows

( ! ) Warning: require(../files/apacheloadedmodules.php): Failed to open stream: No such file or directory in C:\wamp64\www\index.php on line 231
Call Stack
# Time Memory Function Location
1 0.0001 458944 {main}( ) ...\index.php:0

( ! ) Fatal error: Uncaught Error: Failed opening required '../files/apacheloadedmodules.php' (include_path='.;C:\php\pear') in C:\wamp64\www\index.php on line 231
( ! ) Error: Failed opening required '../files/apacheloadedmodules.php' (include_path='.;C:\php\pear') in C:\wamp64\www\index.php on line 231
Call Stack
# Time Memory Function Location
1 0.0001 458944 {main}( ) ...\index.php:0

Would you advise again, please ?

This is frustrating!
So we'll start again with what was working, namely:
- WAMP Version 3.3.7 - 64-bit
- Apache 2.4.62.1
- PHP 8.3.14
- MySQL 9.1.0
- MariaDB 11.5.2

To do this:
Since clicks do not seem to be working, open a command window "as administrator" and, using CD commands
CD /D C:\wamp64
go to:
C:\wamp64
- Type the following commands in succession:
net stop wampapache64
net stop wampmysqld64
net stop wampmariadb64
taskkill /F /IM wampmanager.exe
sc delete wampapache64
sc delete wampmysqld64
sc delete wampmariadb64

Check, via the services manager, that the wampapache64, wampmysqld64, and wampmariadb64 services no longer exist.
- If this is not the case, do not continue.

Rename C:\wamp64 to C:\wamp64_new, for example.
Rename C:\wamp64_old to C:\wamp64.

In a command window "as administrator," go to the Apache bin folder.
CD /D C:\wamp64\bin\apache\apache2.4.62.1\bin
- Create the service using the following commands:
httpd.exe -n wampapache64 -k install
sc config wampapache64 start=demand

Go to the mysql bin folder
CD /D C:\wamp64\bin\mysql\mysql9.1.0\bin
- Create the service using the command:
mysqld.exe --install-manual wampmysqld64

Go to the mariadb bin folder:
CD /D C:\wamp64\bin\mariadb\mariadb11.5.2\bin
- Create the service using the command:
mysqld.exe --install-manual wampmariadb64

The three services are now installed.
You can launch Wampserver and you will find your old version.

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