WAMP won't switch to MySQL 8.0.17
Posted by: bfarberdev2 (50.28.55.---)
Date: July 24, 2019 07:12PM

I upgraded to WAMP 3.1.9 today using the "WAMP update" executable, and then I downloaded and installed MySQL 8.0.17. I didn't run into any issues (well, except I tried to do MySQL first and was blocked until I upgraded WAMP itself) in this process.


I then changed the version in the WAMP menu, and didn't run into any issues with this process either. It shows as activated and all menu options show as using version 8.0.17. I even opened the wampmanager conf file and confirmed 8.0.17 is being pointed to.



upload images


Unfortunately, however, the system is still using version 5.7 and I can't seem to figure out why or how to get it switched over properly.



upload images


I have tried the following without luck:

1. (right click) -> Refresh,
2. Switching the version through the WAMP manager back to 5.7.21, then back to 8.0.17
3. Removing the service and reinstalling the service through the WAMP manager while on 8.0.17


But for some reason MySQL 5.7.21 is still running, when I want to run 8.0.17. Any tips or advice as for what I can check to find out why the wrong version of MySQL is running?

Options: ReplyQuote
Re: WAMP won't switch to MySQL 8.0.17
Posted by: bfarberdev2 (50.28.55.---)
Date: July 24, 2019 07:17PM

Sorry, and for posterity

Windows 64, version 10.0.17134 Build 17134
WampServer version 3.1.9 64bit
Apache 2.4.37 is currently running
PHP 7.3.0 is currently running
MySQL 8.0.17 shows as selected, but 5.7.21 is currently running
WampServer icon is green
Hosts file:
127.0.0.1 localhost
::1 localhost
Localhost is loading fine
I have access to phpMyAdmin (which also reports version 5.7.21 running)
No error messages
Windows built in firewall is active and I use Avast for antivirus
WAMP is installed to c:/wamp
I have several virtual hosts configured but none of these are relevant to the question at hand

Options: ReplyQuote
Re: WAMP won't switch to MySQL 8.0.17
Posted by: Otomatic (Moderator)
Date: July 24, 2019 08:01PM

Hi,

I don't understand !

Verify:
- wampmanager.conf
[mysql]
mysqlVersion = "8.0.17"

- Service manager - service wampmysqld64 properties
Path of executable files (Translation from my French Windows)
C:\wamp\bin\mysql\mysql8.0.17\bin\mysqld.exe wampmysqld64

From service manager try to stop then start the service

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.0 32 bit - Apache 2.4.41 - PHP 7.4.0/7.3.12/..../5.6.40 - MySQL 5.7.28 - MariaDB 10.4.10
Wampserver 3.2.0 64 bit - Apache 2.4.41 - PHP 7.4.0/7.3.12/..../5.6.40 - MySQL 5.7.28/8.0.18 - MariaDB 10.4.10
PhPMyadmin 4.9.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: WAMP won't switch to MySQL 8.0.17
Posted by: bfarberdev2 (50.28.55.---)
Date: July 24, 2019 10:10PM

In wampmanager.conf I have

[mysql]
mysqlVersion = "8.0.17"
mysqlConfDir = "."
mysqlConfFile = "my.ini"
mysqlExeDir = "bin"
mysqlExeFile = "mysqld.exe"
mysqlServiceInstallParams ="--install-manual wampmysqld64"
mysqlServiceRemoveParams ="--remove wampmysqld64"
[mysqloptions]
mysqlPortUsed = "3306"
mysqlUseOtherPort = "off"
mysqlUseConsolePrompt = "off"
mysqlConsolePrompt= "\U-MySQL\v-['\d']>"
mysqlPortOptionsMenu= "on"


The service is showing the path to executable incorrectly, however, which explains the problem:

c:\wamp\bin\mysql\mysql5.7.21\bin\mysqld.exe wampmysqld64

Like I said, with MySQL 8.0.17 enabled in the WAMP menu I have already used the "Remove Service" and then "Install Service" options. How can I get the service updated to point to the correct executable?



Edited 1 time(s). Last edit at 07/24/2019 10:11PM by bfarberdev2.

Options: ReplyQuote
Re: WAMP won't switch to MySQL 8.0.17
Posted by: Otomatic (Moderator)
Date: July 24, 2019 10:23PM

Hi,

Open a command window as administrator then type :

sc delete wampmysqld64

Exit command window

Launch Wampserver

Left-click -> Mysql -> Service administration -> Install Service

Then the same with Start Service

Sorry, It is not very easy to write explanations with a Smartphone.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.0 32 bit - Apache 2.4.41 - PHP 7.4.0/7.3.12/..../5.6.40 - MySQL 5.7.28 - MariaDB 10.4.10
Wampserver 3.2.0 64 bit - Apache 2.4.41 - PHP 7.4.0/7.3.12/..../5.6.40 - MySQL 5.7.28/8.0.18 - MariaDB 10.4.10
PhPMyadmin 4.9.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: WAMP won't switch to MySQL 8.0.17
Posted by: bfarberdev2 (50.28.55.---)
Date: July 24, 2019 10:30PM

I had already started tinkering before your reply, but effectively took the same steps and I've got it on 8.0.17 now. Thanks for the help!

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.17    |
+-----------+
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Sorry, only registered users may post in this forum.