WAMP 3新安装尝试了所有功能
WAMP 3新安装尝试了所有功能
提问于 2016-08-30 02:02:55
今天我决定在Windows10上重新安装WAMP。
这是一个多么错误的错误，在新的安装之后，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。
我将wamp目录的名称更改为: wampOld
我检查了我的服务，上面没有mysql或apache
我安装了所需的所有VC包(以管理员身份)：
我在windows上检查了IIS，在我看来一切正常: Web管理工具和它下面的所有东西都是未勾选的。
我安装了WAMP (作为administrator)(wampserver3.0.4_x64_apache2.4.18_mysql5.7.11_php5.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.19Apache错误日志：
[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安装后，我的服务如下所示：
我的hosts文件中有以下两个条目: 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我错过了什么？
回答 3
Stack Overflow用户
发布于 2018-06-05 06:22:55
我通过删除(或重命名)目录解决了这个问题
C:\wamp64\bin\mysql\mysql5.7.21\data然后执行
./mysqld --initialize-insecure从…
C:\wamp64\bin\mysql\mysql5.7.21\binStack Overflow用户
发布于 2016-08-30 15:58:02
解决方案是：
安装WAMP 2.5
运行从2.5到3的升级文件。
最后，它起作用了。
Stack Overflow用户
发布于 2019-09-17 13:56:27
无论何时安装WAMP，请将其安装在新的文件夹中。
对于Visual C发行版，请从http://wampserver.aviatechno.net下载以下Visual C++可再发行组件包
Microsoft VC++ Packages x86 (32位)
- VC 2008 SP1 Package (x86) MD5
- VC 2008 SP1 MD5 Package (x86) MD5
- VC 2008 SP1 MFC Package (x86) MD5
- VC 2010 SP1 Package (x86)
- VC 2012更新4()
- VC 2013 Package Up 5()
- VC 2015-2019 () 14.22.27821
以及：
- VC 2008 SP1 Package (x64) MD5
- VC 2008 SP1 ATL Package (x64) MD5
- VC 2008 SP1 MFC Package (x64) MD5
- VC 2010 SP1 Package (x64)
- VC 2012 Up 4()
VC 2013 Up 5()
- VC 2015-2019 () 14.22.27821 MD5
另一种方法是下载以下内容：
微软VC包VC2008、2010、2012、2013、2015-2019压缩文件
- 所有VC可再发行软件包(x86) (32位) MD5
- 所有VC可再发行软件包(x86_x64) (32位和64位) MD5
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39212415
复制相关文章
相似问题