Wamp onloy start 2 services
Posted by: ameliabob (---.hsd1.fl.comcast.net)
Date: May 23, 2018 03:00PM

I have been running wamp for about 2 weeks and now it won't complete the startup. i.e. I only get to the orange "w".

Where do I go to find out what is not running?

When I try to start phpMyAdmin I get the error " #2054 - Server sent charset unknown to the client. Please, report to the developers"

Options: ReplyQuote
Re: Wamp onloy start 2 services
Posted by: RiggsFolly (Moderator)
Date: May 23, 2018 03:23PM

hi

I would guess it is the MySQL or mariaDb that is not starting.

Check (right click) wampmanager->Tools->Check State of Service

If this is the case check the MySQL or mariaDB error log

Check (left click) wampmanager->MySQL->MySQL log

I would bet that there is a database corruption and that is stopping the service starting.

If I am wrong, please show us some of the error messages from which ever log matches the problem service and we will try to advise further.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Wamp only start 2 services
Posted by: ameliabob (---.hsd1.fl.comcast.net)
Date: May 23, 2018 03:48PM

From mysql.log is this response:
2018-05-23T13:36:40.009994Z 0 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2018-05-23T13:36:40.011026Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-05-23T13:36:40.011841Z 0 [ERROR] Aborting

How do I shut down 3306? All that is running at this time is the firefox browser.

Options: ReplyQuote
Re: Wamp only start 2 services
Posted by: RiggsFolly (Moderator)
Date: May 23, 2018 04:34PM

Hi

Have you installed something recently that may have come with its own MySQL Server.

It sounds like there is another MySQL Server running on your system. Remember MySQL server runs as a service and therefore will not show up in the running programs list

This normally happens when someone installs something like MySQL Workbench. That comes in 2 flavours one with its own MySQL Server instance and one without.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Wamp onloy start 2 services
Posted by: ameliabob (---.hsd1.fl.comcast.net)
Date: May 23, 2018 06:10PM

Would this include something like the 'node' system?

Options: ReplyQuote
Re: Wamp onloy start 2 services
Posted by: Otomatic (Moderator)
Date: May 23, 2018 09:17PM

Hi,

What is the result of
Right-click Wampmanager tray icon -> Tools -> Test port 3306

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
PhPMyadmin 4.8.3 - 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.