WampServer

1 - Windows version used: Server 2016, 64 bit
2 - Version WampServer: 3.2.5, 64 bit
3 - Apache Version: 2.4.47
4 - PHP Version: 7.4.19
5 - MySQL Version: 5.7.23
6 - What color is the WampServer icon: Green
7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines?
127.0.0.1 localhost
::1 localhost
8 - Do you have access to localhost (Homepage WampServer)? Yes
8a - If so, is there an error message at the bottom of the page? No
9 - Do you have access to phpMyAdmin? Yes
10 - If you refer to an error message, please include the EXACT wording of the error in your post
11 - If you use an Antivirus and / or Firewall, please include the names of these: Windows Defender, Windows Firewall is disabled.
12 - What is the full path to the installation of WampServer (eg D:\wamp\): C:\wamp64
13 - If you have one or more Virtual Hosts defined, please show their definition(s): localhost

I am working on upgrading our WAMP server and got everything done except MySQL. I have installed two newer versions, 5.7.34 and 8.0.25, and when I select one of them in the WAMP interface it shows the correct version on the homepage but phpMyAdmin still shows 5.7.23.

I verified that I have all of the Visual C++ Redistribuable Packages installed and have restarted the server several times but cant seem to get the MySQL version to switch in phpMyAdmin, I am running 5.1.1 by the way. Any recommendations?

Hi,

> 5 - MySQL Version: 5.7.23
> but phpMyAdmin still shows 5.7.23.

This is quite normal !
The MySQL version used by Wampserver is the one you have in answer 5 above, it is the active version.
PhpMyAdmin only uses the chosen version, not the ones you have installed, as they are not active.

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

Thank you for your reply Otomatic. The reason I am upgrading the server is to eliminate security vulnerabilities in the software. I have switched the MySQL version but our security scanner is still reporting the same vulnerabilities. Do you happen to know how I can confirm the version of MySQL being used?

Hi,

The MySQL version you are using is the one you see on the right side of MySQL after you left-click on the Wampmanager icon.
It should also say: Default DBMS: MySQL

See : Left-Click -> Help -> MariaDB - MySQL

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

I checked out the Help you listed and found the "testmysql" URL. When I run the test it says "Server 5.7.23" but when I check the MySQL version in the WAMP menu it shows the selected version as being 8.0.25. It looks like the MySQL version is not being changed, do you know what could be causing this?

I took screenshots to show what I have running but can't figure out how to add them to my message.

Hi,

Right-Click -> Tools -> Empty logs -> Empty all logs files -> Y

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

Hi,

What is the result of :

Right-Click -> Tools -> Check state of services

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

Looks like there is something wrong with the MySQL service, see below. I will try the reinstall like it says.


State of services:

The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmysqld64' is started
Service Session : LocalSystem

The service 'wampmariadb64' is started
Service Session : LocalSystem

all services are started - it is OK

***** One or more BINARY_PATH_NAME is incorrect *****
*** BINARY_PATH_NAME of the service wampmysqld64 is not the good one:
c:/wamp64/bin/mysql/mysql5.7.23/bin/mysqld.exe
*** should be:
c:/wamp64/bin/mysql/mysql8.0.25/bin/mysqld.exe
You should reinstall the services using the integrated Wampserver's tool:
Left-Click-> Apache or MySQL or MariaDB -> Service administration then four steps: Stop, Remove, Install, Start then Right-Click -> Refresh

Reinstalling the MySQL service didn't fix the issue. Running "Check state of services" returns the same message about the MySQL service. Do I need to manually uninstall and reinstall MySQL?

Hi,

Switch back to MySQL 5.7.23 and check that "Check state of services" does not return an error.

Quit and restart Wampserver then switch to MySQL 8.0.25 and check "Check state of services".

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