Mysql Problem
Posted by: Slushgood (109.70.17.---)
Date: December 08, 2022 02:05PM

Hello i'm using Wamp 3.2.6.
For one Prject i need install mysql 5.4. I have download and put folder in Bin of my wamp.
When i have switch on mysql 5 it working fine for the project, but know i want to switch back on mysql 8 wamp do not want.
I have change the mysql version in .init but wampmysql do not want to start. I need to go in services and start it manually. In fact the wam icon stay in orange.
Do you have solution ?

Options: ReplyQuote
Re: Mysql Problem
Posted by: Otomatic (Moderator)
Date: December 08, 2022 02:49PM

Hi,

There is no MySQL version 5.4.x both as a Wampserver addon and at MySQL, where did you get this version?

> I have changed the mysql version in .init
There is no file with the extension .init, you probably mean the file wampmanager.ini

; ** There is no point in modifying the file wampmanager.ini ***
; * The wampmanager.ini file is completely rewritten each time *
; * Wampserver is launched and each time a Wampserver, Apache, *
; * PHP, MySQL or MariaDB option is modified.

To change MySQL version, it is necessary to use:
Left-click -> MySQL -> Version -> choose the desired version

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40/8.0.31 - MariaDB 10.5.17/10.10.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 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: Mysql Problem
Posted by: Slushgood (109.70.17.---)
Date: December 08, 2022 03:15PM

>I have changed the mysql version in .init
wampserver.con *sorry *

To change MySQL version, it is necessary to use:
Left-click -> MySQL -> Version -> choose the desired version
Yep but this option work only once for go to 5.4. After that wampserver Jam itch time i click on version 8
for version 5 i have found it on wamp sourceforge : WampServer2-MYSQL5141.exe
[sourceforge.net]



Edited 2 time(s). Last edit at 12/08/2022 03:25PM by Slushgood.

Options: ReplyQuote
Re: Mysql Problem
Posted by: Otomatic (Moderator)
Date: December 08, 2022 03:32PM

Hi,

> After that wampserver Jam itch time i click on version 8

See error or warning in php_error.log and mysql.log files

And I repeat that there is no mysql5.4.x addon for Wampserver 3, even on Sourceforge

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40/8.0.31 - MariaDB 10.5.17/10.10.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 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: Mysql Problem
Posted by: Slushgood (109.70.17.---)
Date: December 08, 2022 03:47PM

Maybe something in services.
wampapache64
wampmariadb64
wampmysqld
why not 64 for mysql

logs in mysql.log files

Options: ReplyQuote
Re: Mysql Problem
Posted by: Otomatic (Moderator)
Date: December 08, 2022 04:18PM

You delete the wampmysqld service - which comes from who knows where - via a command line :

sc delete wampmysqld

For information, the names of the services come from the [service] section of the wampmanager.conf file

then launch Wampserver and
Left-click -> MySQL -> Service administration [wampmysqld64] -> Install service
Left-click -> MySQL -> Service administration [wampmysqld64] -> Start/Resume service

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…7.4.33 - MySQL 5.7.40/8.0.31 - MariaDB 10.5.17/10.10.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 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: Mysql Problem
Posted by: Slushgood (109.70.17.---)
Date: December 08, 2022 05:01PM

ok i found the problem

in wampmanager.conf
need replace
mysqlServiceInstallParams = "--install-manual wampmysqld"
mysqlServiceRemoveParams = "--remove wampmysqld"
with
mysqlServiceInstallParams = "--install-manual wampmysqld64"
mysqlServiceRemoveParams = "--remove wampmysqld64"
and recreat wampmysql service



Edited 2 time(s). Last edit at 12/08/2022 05:17PM by Slushgood.

Options: ReplyQuote


Sorry, only registered users may post in this forum.