MySQL not starting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: December 18, 2021 11:37AM

Since some time wampserver refuses to start mySQL. Apache / MariaDB start fine. Things I checked

* There is not another mysql running and the designated port is free
* Repaired the wampserver.ini
* reinstalled all vc++
* ran mysqld.exe manually (it works fine)
* log files mysql.log is empty

I installed a 8.0.27 but it does not show up in the menu. If I click any of the Service Start/Stop/Restart button nothing happens and the menu stays open.

How can I repair the MySQL section of wampserver without compromising the working parts?

Options: ReplyQuote
Re: MySQL not starting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: December 18, 2021 11:44AM

--------------------------------------------------
State of services:

The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmariadb64' is started
Service Session : LocalSystem

all services are started - it is OK

all services BINARY_PATH_NAME are OK
--------------------------------------------------
*** Checking the DNS search order ***

Values of registry keys for
HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\ServiceProvider
are in correct order

--------------------------------------------------
Wampmanager (Aestan Tray Menu) 3.2.4.2 - 64bit

Compiler Visual C++ versions used:

PHP 5.6.40 Compiler => MSVC11 (Visual C++ 2012) - Architecture => x64

PHP 7.4.25 Compiler => Visual C++ 2017 - Architecture => x64

PHP 7.4.9 Compiler => Visual C++ 2017 - Architecture => x64

PHP 8.0.11 Compiler => Visual C++ 2019 - Architecture => x64



MariaDB Ver 10.5.4-MariaDB for Win64 on AMD64 (mariadb.org binary distribution)
MariaDB Ver 10.6.4-MariaDB for Win64 on AMD64 (mariadb.org binary distribution)

Apache 2.4.46 Apache Lounge VS16 Server built: Aug 2 2020 10:21:32
Architecture: 64-bit
--------------------------------------------------
VirtualHost configuration:

Default server: localhost
Virtual Host: localhost
Virtual Host: dwh.guerbet.local
Virtual Host: demo.local
--------------------------------------------------
***** Check symbolic links *****

All symbolic links are OK
--------------------------------------------------
***** Test which uses port 80 *****

===== Tested by command netstat filtered on port 80 =====


Test for TCP
Your port 80 is used by a processus with PID = 11292
The processus of PID 11292 is 'httpd.exe' Session: Services
The service of PID 11292 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 80 is used by a processus with PID = 11292
The processus of PID 11292 is 'httpd.exe' Session: Services
The service of PID 11292 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct

===== Tested by attempting to open a socket on port 80 =====

Your port 80 is actually used by :

Server: Apache/2.4.46 (Win64) PHP/7.4.25
--------------------------------------------------
***** Test which uses port 3308 *****

===== Tested by command netstat filtered on port 3308 =====

Port 3308 is not found associated with TCP protocol
Port 3308 is not found associated with TCP protocol
--------------------------------------------------
***** Test which uses port 3306 *****

===== Tested by command netstat filtered on port 3306 =====


Test for TCP
Your port 3306 is used by a processus with PID = 9360
The processus of PID 9360 is 'mysqld.exe' Session: Services
The service of PID 9360 for 'mysqld.exe' is 'wampmariadb64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 3306 is used by a processus with PID = 9360
The processus of PID 9360 is 'mysqld.exe' Session: Services
The service of PID 9360 for 'mysqld.exe' is 'wampmariadb64'
This service is from Wampserver - It is correct
--------------------------------------------------
State of services:

The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmariadb64' is started
Service Session : LocalSystem

all services are started - it is OK

all services BINARY_PATH_NAME are OK
--------------------------------------------------
*** Checking the DNS search order ***

Values of registry keys for
HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\ServiceProvider
are in correct order

--------------------------------------------------
Wampmanager (Aestan Tray Menu) 3.2.4.2 - 64bit

Compiler Visual C++ versions used:

PHP 5.6.40 Compiler => MSVC11 (Visual C++ 2012) - Architecture => x64

PHP 7.4.25 Compiler => Visual C++ 2017 - Architecture => x64

PHP 7.4.9 Compiler => Visual C++ 2017 - Architecture => x64

PHP 8.0.11 Compiler => Visual C++ 2019 - Architecture => x64



MariaDB Ver 10.5.4-MariaDB for Win64 on AMD64 (mariadb.org binary distribution)
MariaDB Ver 10.6.4-MariaDB for Win64 on AMD64 (mariadb.org binary distribution)

Apache 2.4.46 Apache Lounge VS16 Server built: Aug 2 2020 10:21:32
Architecture: 64-bit
--------------------------------------------------
VirtualHost configuration:

Default server: localhost
Virtual Host: localhost
Virtual Host: dwh.guerbet.local
Virtual Host: demo.local
--------------------------------------------------
***** Check symbolic links *****

All symbolic links are OK
--------------------------------------------------
***** Test which uses port 80 *****

===== Tested by command netstat filtered on port 80 =====


Test for TCP
Your port 80 is used by a processus with PID = 16620
The processus of PID 16620 is 'httpd.exe' Session: Services
The service of PID 16620 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 80 is used by a processus with PID = 16620
The processus of PID 16620 is 'httpd.exe' Session: Services
The service of PID 16620 for 'httpd.exe' is 'wampapache64'
This service is from Wampserver - It is correct

===== Tested by attempting to open a socket on port 80 =====

Your port 80 is actually used by :

Server: Apache/2.4.46 (Win64) PHP/7.4.25
--------------------------------------------------
***** Test which uses port 3308 *****

===== Tested by command netstat filtered on port 3308 =====

Port 3308 is not found associated with TCP protocol
Port 3308 is not found associated with TCP protocol
--------------------------------------------------
***** Test which uses port 3306 *****

===== Tested by command netstat filtered on port 3306 =====


Test for TCP
Your port 3306 is used by a processus with PID = 16948
The processus of PID 16948 is 'mysqld.exe' Session: Services
The service of PID 16948 for 'mysqld.exe' is 'wampmariadb64'
This service is from Wampserver - It is correct

Test for TCPv6
Your port 3306 is used by a processus with PID = 16948
The processus of PID 16948 is 'mysqld.exe' Session: Services
The service of PID 16948 for 'mysqld.exe' is 'wampmariadb64'
This service is from Wampserver - It is correct

Options: ReplyQuote
Re: MySQL not starting
Posted by: Otomatic (Moderator)
Date: December 18, 2021 12:06PM

Hi,

> State of services:
The wampmysqld64 service does not appear in the list. This may mean that MySQL has been disabled.

- 1 - Exit Wampserver

- 2 - Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
Do not use a previously loaded tool. Make a new download to make sure you are using the correct version.[/u)
To download missing packages, do not rely on Microsoft links, they are not reliable, download packages on http://wampserver.aviatechno.net in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.

- 3 - If it is not already done, apply Update 3.2.7 to your version of Wampserver
Wampserver update 3.2.7

- 4 - Launch Wampserver

- 5 - Right-Click -> Restart from zero

- 6 - Verify that MySQL is allowed
Right-Click -> Wamp settings -> Allow MySQL to check it

Note: To make a complete report of the Wampserver configuration, there is an integrated tool that automatically performs all the operations and avoids multiple copy/paste, it is :

Right-Click -> Tools -> Create Wampserver configuration report
And, at the end the report file is :
Right-Click -> Tools -> Wampserver Configuration report

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.8 32 bit - Apache 2.4.52 - PHP 8.1.2…5.6.40 - MySQL 5.7.37 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.8 64 bit - Apache 2.4.52 - PHP 8.1.2…5.6.40 - MySQL 5.7.37/8.0.28 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.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 »



Edited 1 time(s). Last edit at 12/18/2021 02:17PM by Otomatic.

Options: ReplyQuote
Re: MySQL not starting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: January 08, 2022 11:42AM

mySQL used to run on this machine so I rule out missing redistribution libraries, the current c++ check tool confirms that.

Options: ReplyQuote
Re: MySQL not starting
Posted by: Otomatic (Moderator)
Date: January 08, 2022 12:03PM

Hi,

Quote

State of services:
The service 'wampapache64' is started
Service Session : LocalSystem

The service 'wampmariadb64' is started
Service Session : LocalSystem

all services are started - it is OK
Since there are only two services and wampmysql64 is not listed, I repeat that this means that MySQL has been disabled on your Wampserver.

Redo point 6 of my previous message.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.8 32 bit - Apache 2.4.52 - PHP 8.1.2…5.6.40 - MySQL 5.7.37 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.8 64 bit - Apache 2.4.52 - PHP 8.1.2…5.6.40 - MySQL 5.7.37/8.0.28 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.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


Sorry, only registered users may post in this forum.