WAMP server icon stuck on orange, mysql server not starting.
Posted by: Yamakasinge (80.12.102.---)
Date: March 01, 2019 01:49PM

Hey,

After installing wamp, mysql is not starting and wamp logo is stuck on orange.

Here is the mysql log :


2019-03-01T13:00:09.743626Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2019-03-01T13:00:09.751625Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f1a980f4-3c21-11e9-ae00-ec8eb573a548.
2019-03-01T13:00:09.757625Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-03-01T13:00:09.765624Z 0 [Warning] Failed to open optimizer cost constant tables

2019-03-01T13:00:09.766624Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: La table 'mysql.user' n'existe pas
2019-03-01T13:00:09.767624Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2019-03-01T13:00:09.768624Z 0 [ERROR] Aborting

Options: ReplyQuote
Re: WAMP server icon stuck on orange, mysql server not starting.
Posted by: RiggsFolly (Moderator)
Date: March 01, 2019 02:05PM

Hi,

This sounds like the Install of MySQL had a problem.
This is normally because one of the MSVC Runtime libraries is not available.

The first dialog from the Install script asks you to check that you have all the MSVC Runtimes install BEFORE continuing with the install. Did you do that

See the bottom of this page, the backup repo for WAMPServer. At the bottom you will find a download that contains all the MSVC Runtimes and also a little utility that will check your system and tell you which are missing.

Please remember to install both the 32bit AND 64bit Runtimes if you are on a 64bit Windows system.
You shoudl install them in Version number order, if one reports it is present use the REPAIR option. This will ensure you have the latest version installed.

You will have to UNINSTALL WAMPServer, make sure the wamp or wamp64 folder is deleted, and then install the MSVC Runtime Libraries.
Once this is complete you can re-install WAMPServer.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.7 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <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-



Edited 2 time(s). Last edit at 03/01/2019 02:07PM by RiggsFolly.

Options: ReplyQuote
Re: WAMP server icon stuck on orange, mysql server not starting.
Posted by: Yamakasinge (80.12.67.---)
Date: March 01, 2019 02:31PM

Thanks !

Options: ReplyQuote


Sorry, only registered users may post in this forum.