mysql - Windows 8.1 XAMPP MySQL 服务检测到路径错误

Question

我是这个论坛的新手，所以请多多包涵。我已经尝试了几个小时让 MySQL 在我第一次安装的 Windows 8.1 的 XAMPP 中启动。错误代码如下。根据我读过的其他帖子，这是我已经尝试过的:它说我没有以管理员权限运行，但我去了控制面板用户帐户，它说我是管理员并且是唯一的管理员我进入 Program Files(x86)，那里没有 MySQL 文件夹。我试着进入服务。 MySQL 已停止。我无法启动它；它说 Windows 找不到该文件。我编辑了 MySQL 和 php 的 ini 文件，将端口从 3306 更改为 3308。我尝试进入 cmd 以删除 mysql 并创建一个服务条目。两次我都收到一条错误消息，内容为“打开服务失败 5:访问被拒绝。我将不胜感激您能提供的任何帮助以使其正常工作。谢谢。

7:32:33 PM  [main]  Initializing Control Panel
7:32:33 PM  [main]  Windows Version: Windows 8  64-bit
7:32:33 PM  [main]  XAMPP Version: 1.8.3
7:32:33 PM  [main]  Control Panel Version: 3.2.1  [ Compiled: May 7th 2013 ]
7:32:33 PM  [main]  You are not running with administrator rights! This will work for
7:32:33 PM  [main]  most application stuff but whenever you do something with services
7:32:33 PM  [main]  there will be a security dialogue or things will break! So think 
7:32:33 PM  [main]  about running this application with administrator rights!
7:32:33 PM  [main]  XAMPP Installation Directory: "c:\xampp\"
7:32:33 PM  [main]  Checking for prerequisites
7:32:33 PM  [main]  All prerequisites found
7:32:33 PM  [main]  Initializing Modules
7:32:33 PM  [Apache]    XAMPP Apache is already running on port 80
7:32:33 PM  [Apache]    XAMPP Apache is already running on port 443
7:32:33 PM  [mysql]     MySQL Service detected with wrong path
7:32:33 PM  [mysql]     Change XAMPP MySQL and Control Panel settings or
7:32:33 PM  [mysql]     Uninstall/disable the other service manually first
7:32:33 PM  [mysql]     Found Path: "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
7:32:33 PM  [mysql]     Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
7:32:33 PM  [main]  Starting Check-Timer
7:32:33 PM  [main]  Control Panel Ready
7:32:41 PM  [mysql]     Attempting to start MySQL service...

Answer 1

开始 -> 运行 -> regedit。

It involves editing the registry, but service information can be found in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services. Find the mysql service you want to redirect, locate the ImagePath subkey and change that value.

在那里你可以设置你的默认路径:)