Xampp Mysql 无法启动
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19613099/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Xampp Mysql wont start
提问by Shaun Davies
I have read all the posts about this none fix it? please help ive even tryed re-installing my computer and reinstalling xampp
我已经阅读了有关此问题的所有帖子，但都没有解决吗？请帮助我什至尝试重新安装我的计算机并重新安装 xampp
Errors:
错误：
00:33:43 [mysql] Problem detected!
00:33:43 [mysql] Port 3306 in use by ""C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini" MySQL"!
00:33:43 [mysql] MySQL WILL NOT start without the configured ports free!
00:33:43 [mysql] You need to uninstall/disable/reconfigure the blocking application
00:33:43 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
00:33:43 [mysql] Attempting to start MySQL service...
Then i get a user account control to allow changes when i try to start mysql? something to do with net.exe? in C:\Windows, im not sure of the rest of the directory
然后，当我尝试启动 mysql 时，我会获得一个用户帐户控制以允许更改吗？与net.exe有关吗？在 C:\Windows 中，我不确定目录的其余部分
If i say no to the user account cocntrol then it says this 00:33:49 [mysql] There may be an error, return code: 1223 - The operation was cancelled by the user.
如果我对用户帐户 cocntrol 说不，那么它会说这个 00:33:49 [mysql] 可能有错误，返回代码：1223 - 操作被用户取消。
If i say yes nothing happens? Apparently its windows 5.1 erroring? but the directory doesnt even exist? i deleted it all from Program Files and Program Files (x86), Also uninstalled all mysql components? Any thoughts
如果我说是，什么都不会发生？显然它的 Windows 5.1 出错了？但该目录甚至不存在？我从 Program Files 和 Program Files (x86) 中删除了它，还卸载了所有 mysql 组件？有什么想法吗
回答by kmas
Here is the way to know the program, use netstat -ao
这是了解程序的方法，使用 netstat -ao
You have the port and the associated pid.
您拥有端口和关联的 pid。
Get the pid for 3306.
获取 3306 的 pid。
Then launch taskmgr
然后启动 taskmgr
Show column pid(Menu > Select > Column selection > check PID)
显示列pid（菜单 > 选择 > 列选择 > 检查 PID）
- You know the program which uses this 3306 port.
- Kill it
- Restart your XAMP
- 您知道使用此 3306 端口的程序。
- 杀了它
- 重启你的 XAMP
Then for not starting this "3306 port" program, launch services.msc.
然后为了不启动这个“3306 端口”程序，启动services.msc.
It is certainly a MySQL, search for it and desactivate it at startup.
它肯定是一个 MySQL，搜索它并在启动时停用它。
回答by Noor
I had the same problem. I was using standalone MySQlfor Java, and then I install XAMPPeven after uninstalling stand-alone MySQL, XAMPP MySQLwouldn't start.
The problem is even after uninstalling MySQL MySQL serviceis normally still in the registry. The solution is to remove MySQL servicefrom registry. The easiest way to do this, run XAMP-controlin Administratormode, and remove MySQLfrom servicelist and start MySQLagain. That's it
我有同样的问题。我在MySQlJava中使用了 standalone ，然后XAMPP即使在卸载了 stand-alone 之后安装MySQL，XAMPP MySQL也无法启动。问题是即使卸载 MySQL 后，MySQL service它通常仍然在注册表中。解决方案是MySQL service从registry. 最简单的方法是XAMP-control在Administrator模式下运行，然后MySQL从service列表中删除并重新开始MySQL。就是这样
回答by lefdilia
yes i already get this, the problem is that you already install MySQL as standalone version OR with VM i guess , and then you install xampp, the solution for that, is open process monitor, and close MySQL, MySQL Server 5.1 then you can start xampp and will work fine ^^
是的，我已经明白了，问题是您已经将 MySQL 作为独立版本安装或与 VM 一起安装，然后您安装 xampp，解决方案是打开进程监视器，然后关闭 MySQL、MySQL Server 5.1，然后您可以启动xampp 可以正常工作^^
回答by Behnam Mohammadi
close Xampp server go to C:\xampp\mysql\data delete the ibdata1 file restart xampp server
关闭Xampp服务器去C:\xampp\mysql\data删除ibdata1文件重启xampp服务器
回答by Mars
I just uninstall the register service using
我只是使用卸载注册服务
sc delete MySQL
and restart my xmapp service; then it works OK.
并重新启动我的 xmapp 服务；然后它工作正常。
