我的XAMPP无法开启mysql服务

来源:2-2 mysql图形化管理工具

Unicorn_Outliers

2017-07-06

http://szimg.mukewang.com/595df3f80001789006820441.jpg


16:17:43  [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!

16:17:43  [mysql] MySQL WILL NOT start without the configured ports free!

16:17:43  [mysql] You need to uninstall/disable/reconfigure the blocking application

16:17:43  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

16:17:43  [main] Starting Check-Timer

16:17:43  [main] Control Panel Ready

16:17:51  [Apache] Attempting to start Apache app...

16:17:51  [Apache] Status change detected: running

16:17:53  [mysql] Problem detected!

16:17:53  [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!

16:17:53  [mysql] MySQL WILL NOT start without the configured ports free!

16:17:53  [mysql] You need to uninstall/disable/reconfigure the blocking application

16:17:53  [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

16:17:53  [mysql] Attempting to start MySQL app...

16:17:54  [mysql] Status change detected: running

16:17:59  [mysql] Status change detected: stopped

16:17:59  [mysql] Error: MySQL shutdown unexpectedly.

16:17:59  [mysql] This may be due to a blocked port, missing dependencies, 

16:17:59  [mysql] improper privileges, a crash, or a shutdown by another method.

16:17:59  [mysql] Press the Logs button to view error logs and check

16:17:59  [mysql] the Windows Event Viewer for more clues

16:17:59  [mysql] If you need more help, copy and post this

16:17:59  [mysql] entire log window on the forums

16:23:32  [mysql] Problem detected!

16:23:32  [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!

16:23:32  [mysql] MySQL WILL NOT start without the configured ports free!

16:23:32  [mysql] You need to uninstall/disable/reconfigure the blocking application

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

16:23:32  [mysql] Attempting to start MySQL app...

16:23:32  [mysql] Status change detected: running

16:23:35  [mysql] Status change detected: stopped

16:23:35  [mysql] Error: MySQL shutdown unexpectedly.

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

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

16:23:35  [mysql] Press the Logs button to view error logs and check

16:23:35  [mysql] the Windows Event Viewer for more clues

16:23:35  [mysql] If you need more help, copy and post this

16:23:35  [mysql] entire log window on the forums

请问是什么原因?O(∩_∩)O谢谢

写回答

1回答

NavCat

2017-07-06

C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe
你本地已经装了mysql了,端口3306已经被占用。
解决方案:
方案1,卸载之前装的mysql5.7或停止改服务再启动
方案2,更改mysql的端口

0
0

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

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

2024 学习 · 376 问题

查看课程