Wampserver 3.1.0 Icon orange
Posted by: cargep (---.cust.vodafonedsl.it)
Date: March 19, 2018 11:34PM

Hi guys, I'm in a swamp and I can not get out of it,
Cause days ago I had the brilliant idea of eliminating Wamp 2.5 (because there was a warning that said to update because the Mysql that used by 2018 would be abandoned) and I installed Wamp 3.1.0.
I've never done it, one of the two services does not start and remains the orange icon instead of green.
The wampmysqld64 service does not start. I tried in every way.
In Windows services (7 to 64bit) the wampmysqld64 service starts it but stops immediately.
I uninstalled Skype, I don't have IIS, I tried to change the port from mysql (3306, 3307, 3308,3309) and I reinstalled all Visual C ++ (VC9 VC10 VC11 VC13 VC14 and VC15).
What can I do more?

Please give me some advice: '(

Geppino

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: RiggsFolly (Moderator)
Date: March 20, 2018 12:49AM

Look in the MySQL Error log, and in theWindows Event Viewer for messages from MYSQL.

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (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 -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: cargep (---.cust.vodafonedsl.it)
Date: March 20, 2018 01:03AM

Yes, thank you,
Mysql.log is this:

2018-03-19T21:39:58.853206Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-03-19T21:40:02.874229Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:40:03.966231Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:40:04.605832Z 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: 15e7cb46-2bbe-11e8-b13e-60eb69104c07.
2018-03-19T21:40:05.744634Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:40:06.774451Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:40:07.008451Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:40:07.133252Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:40:37.413599Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:40:37.429199Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:40:37.429199Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:40:37.429199Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:40:37.429199Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:40:52.156272Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:40:52.156272Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:40:52.156272Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:40:52.156272Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:40:52.156272Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:42:40.437589Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:42:40.437589Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:42:40.437589Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:42:40.437589Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:42:40.437589Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:43:42.308100Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:43:42.308100Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:43:42.308100Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:43:42.308100Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:43:42.323700Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:43:51.931748Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:43:51.931748Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:43:51.931748Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:43:51.931748Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:43:51.931748Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:45:26.046594Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:45:26.046594Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:45:26.046594Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:45:26.046594Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:45:26.046594Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T21:47:20.021153Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T21:47:20.036753Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T21:47:20.036753Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T21:47:20.036753Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T21:47:20.052353Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T22:52:15.802726Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T22:52:15.818326Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T22:52:15.818326Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T22:52:15.818326Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T22:52:15.818326Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T23:28:24.420419Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T23:28:24.436019Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T23:28:24.436019Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T23:28:24.436019Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T23:28:24.436019Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T23:56:43.599925Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T23:56:43.599925Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T23:56:43.615525Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T23:56:43.615525Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T23:56:43.615525Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T23:57:09.885450Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T23:57:09.901050Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T23:57:09.901050Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T23:57:09.901050Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T23:57:09.901050Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-03-19T23:57:33.472765Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-19T23:57:33.473765Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-19T23:57:33.477765Z 0 [Warning] Failed to open optimizer cost constant tables

2018-03-19T23:57:33.479765Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-03-19T23:57:33.480765Z 0 [ERROR] Aborting

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: RiggsFolly (Moderator)
Date: March 20, 2018 10:10AM

OK, so please tell us how did you do the install of WAMPServer 3.

A step by step description please, as it looks like you may have just copied bits of V2.5 over the top of V3.

Also did you read this post before doing the re-install [forum.wampserver.com]

It would be good to know where you differed from this process

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (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 -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: cargep (---.cust.vodafonedsl.it)
Date: March 20, 2018 11:19AM

Before proceeding I uninstalled wamp 2.5
Then I installed Visual C ++ (VC9), (VC10), (VC11), (VC13), (VC14), (VC15) in the x86 and x64 versions (as administrator).
But I can redo everything (I uninstall Wamp, reinstall the libraries and then install wamp 3.1.0)
I'm not sure if with the removal of wamp 2.5 it also deleted the folder (but I do not think it's important).
Before proceeding I uninstalled Skype and I checked that IIS was missing on my PC.
The default installation of Wampserver 3.1.0 installed the program in c: \ wamp64, by default installing MYSQL 5.7.19, PHP 5.6.31 and APACHE 2.4.27.
Then I checked with Checks VC ++ packages and says that all the pachages are installed correctly.
I do not know what to do, I start all over again? (I remove Wamp, install libraries, etc.)?

Help me

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: RiggsFolly (Moderator)
Date: March 20, 2018 12:38PM

So you are not trying to recover any databases/websites?

It sounds like you forgot to run the install "As an Administrator"
There are some stpes in the install that require Admin privilages, one being the building of the MySQL and mariaDB systems.


I suggest you uninstall the current install andthen manually make sure you have removed the C:\wamp64 folder

The reinstall but remembering to do it As an Administrator

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (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 -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Wampserver 3.1.0 Icon orange
Posted by: cargep (---.cust.vodafonedsl.it)
Date: March 20, 2018 01:06PM

No, I'm not trying to recover database or website.
I'm doing everything on the pc locally. before removing wamp 2.5 I saved the www folder and all the site databases of the www folder (all the sql file).
After installing wamp 3 I would like to restore the local sites and the databases, but I still do not do so because phpmyadmin does not start (mysqli_real_connect (): (HY000 / 2002): The connection can not be established Persistent refusal of the target computer.)
Now I will try to remove wamp and the wamp64 folder and then reinstall as Administrator

Options: ReplyQuote


Sorry, only registered users may post in this forum.