MySQL服务无法在WAMP上启动?

问题描述

我下载了WAMP的最新版本3.0.6，为此我不知所措. Apache服务可以100％运行，但是WAMP上的MySQL服务拒绝启动，我已经尝试了在stackoverflow上找到的几种解决方案.这是我尝试过的:

I donwloaded the latest version of WAMP which is 3.0.6 and I am at my wits end with this. The Apache services works 100% but the MySQL service on WAMP refuses to start and I have tried several solutions found on stackoverflow. Here is what I have tried:

• 我尝试将端口从3306更改为3307(以及其他在330X范围内的端口)，当我测试端口时，它只是说Port 3307 is not found associated with TCP protocol.即使对于默认的3306端口，它也会显示此

• I tried changing the port from 3306 to 3307 (and others within the 330X range), and when I test the port, it just says Port 3307 is not found associated with TCP protocol. Even for the default 3306 port it says this

我尝试检查MySQL日志，但是它显示为空白文档

I tried checking the MySQL logs but it comes up as a blank document

我尝试在Services.msc中启动wampmysqld64服务，但失败

I tried starting the wampmysqld64 service in Services.msc and it fails

我检查了系统中是否有重复的my.ini文件，但没有

I checked for any duplicate my.ini files on my system and there are none

我卸载了XAMPP，但这并不能解决任何问题

I uninstalled XAMPP, but that didn't fix anything

我尝试禁用防火墙

我尝试手动更改my.ini文件中的端口号

I tried manually changing the port numbers in the my.ini file

我在YouTube上尝试了一个教程，该教程在WAMP上使用了MySQL控制台，但每当尝试输入密码并在尝试超出此范围后关闭时，便会关闭

I tried a tutorial on YouTube that used the MySQL console on WAMP but whenever I try that it asks for a password and closes after I try to proceed beyond that point

我尝试多次卸载并重新安装WAMP

I tried uninstalling and reinstalling WAMP several times

每次更改后，我都重新启动了WAMP和计算机

I have restarted WAMP and my computer after each change I made

我看到一些资源可以删除mysql/data中的某些文件，但在wamp的mysql目录中没有数据文件夹

I saw a few resources said to delete certain files from mysql/data but I do not have a data folder in my mysql directory in wamp

我没有要删除的ib_logfiles或ibdata文件

I don't have any ib_logfiles or ibdata files to delete

我尝试卸载并重新安装MySQL服务

I tried uninstalling and reinstalling the MySQL service

我无法从mysql-bin.index文件中删除任何内容，因为它在我的wamp文件夹中不存在

I can't delete anything from the mysql-bin.index file because it does not exist anywhere in my wamp folder

我尝试使用选项Use port other than 3306并将其从3301-3309更改，它们都不起作用

I tried using the option Use port other than 3306 and changing it from 3301 - 3309, none of them work

我尝试以管理员身份运行wampserver64

I tried running wampserver64 as an administrator

我尝试以管理员身份安装WAMP

I tried installing WAMP as an administrator

我检查了我的Microsoft C/C ++运行时库并拥有所有必需的库

I checked my Microsoft C/C++ Runtime Libraries and have all the required libraries

最后，我的一个朋友下载了与我相同的版本，并且具有与我完全相同的配置，但是他的WAMP可以正常工作.

Lastly, a friend of mine downloaded the same version as me and has the exact same configurations as me but his WAMP works perfectly fine.

我还能尝试什么使MySQL服务在WAMP上运行?

What else can I try to get the MySQL service to run on WAMP?

推荐答案

我有一个类似的问题，该问题是由于MySQL服务已经运行并阻塞端口3306而引起的，此问题通过停止MySQL(或可能是MariaDB)服务得以解决.在Windows中

I had a similar problem that was caused by the MySQL service already running and blocking port 3306, it was solved by stopping the MySQL (or could be MariaDB) service in Windows

这篇关于MySQL服务无法在WAMP上启动?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！