MySQL Service detected with wrong path
启动XAMPP问题如下:
MySQL Service detected with wrong path
11:45:40 [mysql] Change XAMPP MySQL and Control Panel settings or
11:45:40 [mysql] Uninstall/disable the other service manually first
11:45:40 [mysql] Found Path: D:\java\mysql-8.0.23-winx64\mysql-8.0.23-winx64\bin\mysqld.exe
11:45:40 [mysql] Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
11:45:40 [mysql] Problem detected!
11:45:40 [mysql] Port 3306 in use by "Unable to open process"!
11:45:40 [mysql] MySQL WILL NOT start without the configured ports free!
11:45:40 [mysql] You need to uninstall/disable/reconfigure the blocking application
11:45:40 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
解读:
目前已找到的mysqld的文件目录为:D:\java\mysql-8.0.23-winx64\mysql-8.0.23-winx64\bin\mysqld.exe
但是XAMPP希望是:c:\xampp\mysql\bin\mysqld.exe
解决方法
1. win+r 输入regedit 回车
如图:
2. 注册表
如图:
3. 找到mysql注册位置
可直接在上栏输入,也可一步一步找。
计算机\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL
如图:
4. 修改ImagePath的数值数据
点击IMagePath修改数据
这是原数据,保存的是电脑自带mysql的位置
将数值数据修改成XAMPP期望的地址,(直接从上面的报错语句中可以找到)
5.启动XAMPP
启动成功!!!!!!