Wamp 3新安装尝试了一切

内容来源于 Stack Overflow,并遵循CC BY-SA 3.0许可协议进行翻译与使用

  • 回答 (2)
  • 关注 (0)
  • 查看 (449)

今天我决定在Windows 10上重新安装Wamp。

这是一个多么错误的错误,在新安装后,水族图标保持橙色。

我在谷歌搜索了几个小时,尽我所能,没有任何帮助,图标停留在橙色。

我检查了MySQL错误日志,得到如下信息:

2016-08-29T17:43:19.636578Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-08-29T17:43:22.277335Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
wampmysqld64: Table 'mysql.plugin' doesn't exist
2016-08-29T17:43:22.449217Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-29T17:43:22.449217Z 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: 148b018e-6e10-11e6-aca6-a45d36c709dc.
2016-08-29T17:43:22.511719Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-29T17:43:22.527346Z 0 [Warning] Failed to open optimizer cost constant tables

2016-08-29T17:43:22.527346Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-08-29T17:43:22.527346Z 0 [ERROR] Aborting

以下是我所做的:

我把旧水塘弄得乱七八糟的。

我将wamp目录的名称更改为:wampold

我检查了我的服务,上面没有MySQL或Apache。

我安装了所需的所有VC包(作为管理员):

我在Windows上查看了IIS,在我看来还可以:Web管理工具和它下面的所有内容都是取消标记的。

我安装了Wamp(作为管理员)(wampserver3.0.4)_x64_apache2.4.18_mysql5.7.11_5.6.19-7.0.4)

我测试了端口80:

    ***** 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 = 4180
    The processus of PID 4180 is 'httpd.exe' Session: Services
    The service of PID 4180 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 = 4180
    The processus of PID 4180 is 'httpd.exe' Session: Services
    The service of PID 4180 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.18 (Win64) PHP/5.6.19

Apache错误日志:

[Mon Aug 29 19:43:18.777165 2016] [auth_digest:notice] [pid 4180:tid 496] AH01757: generating secret for digest authentication ...
[Mon Aug 29 19:43:18.839665 2016] [mpm_winnt:notice] [pid 4180:tid 496] AH00455: Apache/2.4.18 (Win64) PHP/5.6.19 configured -- resuming normal operations
[Mon Aug 29 19:43:18.839665 2016] [mpm_winnt:notice] [pid 4180:tid 496] AH00456: Apache Lounge VC14 Server built: Dec  9 2015 11:13:29
[Mon Aug 29 19:43:18.839665 2016] [core:notice] [pid 4180:tid 496] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.18\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.18'
[Mon Aug 29 19:43:18.870917 2016] [mpm_winnt:notice] [pid 4180:tid 496] AH00418: Parent: Created child process 6408
[Mon Aug 29 19:43:19.480326 2016] [auth_digest:notice] [pid 6408:tid 432] AH01757: generating secret for digest authentication ...
[Mon Aug 29 19:43:19.558450 2016] [mpm_winnt:notice] [pid 6408:tid 432] AH00354: Child: Starting 64 worker threads.

Apache访问日志:

127.0.0.1 - - [29/Aug/2016:19:43:51 +0200] "GET / HTTP/1.1" 200 5145

安装后,我的服务如下所示:

我的主机文件中有以下两个条目:127.0.0.1 localhost:1 localhost

不,Wamp留下橙色。

卸载,然后安装版本32。还有橙色,在mysql.log中找到了这个:

2016-08-29T20:00:38.680630Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-08-29T20:00:42.132996Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
wampmysqld: Table 'mysql.plugin' doesn't exist
2016-08-29T20:00:42.566098Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-29T20:00:42.590113Z 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: 440b9e23-6e23-11e6-ba24-a45d36c709dc.
2016-08-29T20:00:42.703794Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-29T20:00:43.016750Z 0 [Warning] Failed to open optimizer cost constant tables

2016-08-29T20:00:43.020753Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-08-29T20:00:43.021754Z 0 [ERROR] Aborting

wampmysqld: Table 'mysql.plugin' doesn't exist
2016-08-29T20:01:02.323383Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-29T20:01:02.326385Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-29T20:01:02.328387Z 0 [Warning] Failed to open optimizer cost constant tables

2016-08-29T20:01:02.330389Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-08-29T20:01:02.331389Z 0 [ERROR] Aborting

wampmysqld: Table 'mysql.plugin' doesn't exist
2016-08-29T20:01:26.201624Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-29T20:01:26.203625Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-29T20:01:26.206627Z 0 [Warning] Failed to open optimizer cost constant tables

2016-08-29T20:01:26.208630Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-08-29T20:01:26.210631Z 0 [ERROR] Aborting

我少了什么?

提问于
用户回答回答于

解决办法是:

安装Wamp 2.5

将升级文件从2.5运行到3。

最后,它起作用了。

用户回答回答于

我通过删除(或重命名)目录来解决这个问题。

C:\wamp64\bin\mysql\mysql5.7.21\data

然后执行

./mysqld --initialize-insecure

C:\wamp64\bin\mysql\mysql5.7.21\bin

扫码关注云+社区

领取腾讯云代金券