XAMPP中的MySQL开启失败(老师求救!好急!)

来源:2-3 sql语法基础-创建并使用数据库

冰红茶煮蛋

2018-07-03

15:27:22  [main] Initializing Control Panel

15:27:22  [main] Windows Version:  Enterprise  64-bit

15:27:22  [main] XAMPP Version: 7.2.6

15:27:22  [main] Control Panel Version: 3.2.2  [ Compiled: Nov 12th 2015 ]

15:27:22  [main] You are not running with administrator rights! This will work for

15:27:22  [main] most application stuff but whenever you do something with services

15:27:22  [main] there will be a security dialogue or things will break! So think 

15:27:22  [main] about running this application with administrator rights!

15:27:22  [main] XAMPP Installation Directory: "e:\xampp\"

15:27:22  [main] Checking for prerequisites

15:27:26  [main] All prerequisites found

15:27:26  [main] Initializing Modules

15:27:26  [mysql] Problem detected!

15:27:26  [mysql] Port 3306 in use by "Unable to open process"!

15:27:26  [mysql] MySQL WILL NOT start without the configured ports free!

15:27:26  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:27:26  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:27:26  [main] Starting Check-Timer

15:27:26  [main] Control Panel Ready

15:27:34  [Apache] Attempting to start Apache app...

15:27:35  [Apache] Status change detected: running

15:27:59  [mysql] Problem detected!

15:27:59  [mysql] Port 3306 in use by "Unable to open process"!

15:27:59  [mysql] MySQL WILL NOT start without the configured ports free!

15:27:59  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:27:59  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:27:59  [mysql] Attempting to start MySQL app...

15:28:00  [mysql] Status change detected: running

15:28:03  [mysql] Status change detected: stopped

15:28:03  [mysql] Error: MySQL shutdown unexpectedly.

15:28:03  [mysql] This may be due to a blocked port, missing dependencies, 

15:28:03  [mysql] improper privileges, a crash, or a shutdown by another method.

15:28:03  [mysql] Press the Logs button to view error logs and check

15:28:03  [mysql] the Windows Event Viewer for more clues

15:28:03  [mysql] If you need more help, copy and post this

15:28:03  [mysql] entire log window on the forums

15:29:05  [mysql] Problem detected!

15:29:05  [mysql] Port 3306 in use by "Unable to open process"!

15:29:05  [mysql] MySQL WILL NOT start without the configured ports free!

15:29:05  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:29:05  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:29:05  [mysql] Attempting to start MySQL app...

15:29:06  [mysql] Status change detected: running

15:29:09  [mysql] Status change detected: stopped

15:29:09  [mysql] Error: MySQL shutdown unexpectedly.

15:29:09  [mysql] This may be due to a blocked port, missing dependencies, 

15:29:09  [mysql] improper privileges, a crash, or a shutdown by another method.

15:29:09  [mysql] Press the Logs button to view error logs and check

15:29:09  [mysql] the Windows Event Viewer for more clues

15:29:09  [mysql] If you need more help, copy and post this

15:29:09  [mysql] entire log window on the forums

15:32:31  [mysql] Problem detected!

15:32:31  [mysql] Port 3306 in use by "Unable to open process"!

15:32:31  [mysql] MySQL WILL NOT start without the configured ports free!

15:32:31  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:32:31  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:32:31  [mysql] Attempting to start MySQL app...

15:32:32  [mysql] Status change detected: running

15:32:35  [mysql] Status change detected: stopped

15:32:35  [mysql] Error: MySQL shutdown unexpectedly.

15:32:35  [mysql] This may be due to a blocked port, missing dependencies, 

15:32:35  [mysql] improper privileges, a crash, or a shutdown by another method.

15:32:35  [mysql] Press the Logs button to view error logs and check

15:32:35  [mysql] the Windows Event Viewer for more clues

15:32:35  [mysql] If you need more help, copy and post this

15:32:35  [mysql] entire log window on the forums

15:33:48  [mysql] Problem detected!

15:33:48  [mysql] Port 3306 in use by "Unable to open process"!

15:33:48  [mysql] MySQL WILL NOT start without the configured ports free!

15:33:48  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:33:48  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:33:48  [mysql] Attempting to start MySQL app...

15:33:48  [mysql] Status change detected: running

15:33:51  [mysql] Status change detected: stopped

15:33:51  [mysql] Error: MySQL shutdown unexpectedly.

15:33:51  [mysql] This may be due to a blocked port, missing dependencies, 

15:33:51  [mysql] improper privileges, a crash, or a shutdown by another method.

15:33:51  [mysql] Press the Logs button to view error logs and check

15:33:51  [mysql] the Windows Event Viewer for more clues

15:33:51  [mysql] If you need more help, copy and post this

15:33:51  [mysql] entire log window on the forums

15:36:01  [mysql] Problem detected!

15:36:01  [mysql] Port 3306 in use by "Unable to open process"!

15:36:01  [mysql] MySQL WILL NOT start without the configured ports free!

15:36:01  [mysql] You need to uninstall/disable/reconfigure the blocking application

15:36:01  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

15:36:01  [mysql] Attempting to start MySQL app...

15:36:02  [mysql] Status change detected: running

15:36:05  [mysql] Status change detected: stopped

15:36:05  [mysql] Error: MySQL shutdown unexpectedly.

15:36:05  [mysql] This may be due to a blocked port, missing dependencies, 

15:36:05  [mysql] improper privileges, a crash, or a shutdown by another method.

15:36:05  [mysql] Press the Logs button to view error logs and check

15:36:05  [mysql] the Windows Event Viewer for more clues

15:36:05  [mysql] If you need more help, copy and post this

15:36:05  [mysql] entire log window on the forums


写回答

1回答

NavCat

2018-07-03

你的3306端口被占用了,关掉3306端口的程序再启动

1
2
NavCat
回复
冰红茶煮蛋
是的,也可以通过xampp的界面配置那里更改mysql的端口,然后再启动
2018-07-03
共2条回复

Python操作三大主流数据库-MySQL+MongoDB+Redis

一次实战同时掌握Python操作MySQL,MongoDB,Redis 三大数据库使用技巧

2024 学习 · 376 问题

查看课程