Xampp 和 MySQL 未启动 [英] Xampp and MySQL not started

问题描述

这个问题不知从何而来.

This problem came from nowhere.

我的xampp mysql服务没有启动.这是它在 Xampp 日志中显示的内容.

My xampp mysql service is not started. This is what it shows in Xampp log.

8:20:27 AM  [mysql]     Attempting to start MySQL app...
8:20:27 AM  [mysql]     Executing ""c:\xampp\mysql\bin\mysqld.exe" --defaults-file="c:\xampp\mysql\bin\my.ini" --standalone"
8:20:28 AM  [mysql]     Return code: 0
8:20:28 AM  [mysql]     Status change detected: running
8:20:29 AM  [mysql]     Status change detected: stopped
8:20:29 AM  [mysql]     Error: MySQL shutdown unexpectedly.
8:20:29 AM  [mysql]     This may be due to a blocked port, missing  dependencies, 
8:20:29 AM  [mysql]     improper privileges, a crash, or a shutdown by another method.
8:20:29 AM  [mysql]     Press the Logs button to view error logs and    check
8:20:29 AM  [mysql]     the Windows Event Viewer for more clues
8:20:29 AM  [mysql]     If you need more help, copy and post this
8:20:29 AM  [mysql]     entire log window on the forums

还有日志文件

151206  8:24:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151206  8:24:31 [Note] InnoDB: The InnoDB memory heap is disabled
151206  8:24:31 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151206  8:24:31 [Note] InnoDB: Memory barrier is not used
151206  8:24:31 [Note] InnoDB: Compressed tables use zlib 1.2.3
151206  8:24:31 [Note] InnoDB: Not using CPU crc32 instructions
151206  8:24:31 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151206  8:24:31 [Note] InnoDB: Completed initialization of buffer pool
151206  8:24:31 [Note] InnoDB: Highest supported file format is Barracuda.
151206  8:24:31 [Note] InnoDB: 128 rollback segment(s) are active.
151206  8:24:31 [Note] InnoDB: Waiting for purge to start
151206  8:24:31 [Note] InnoDB:  Percona XtraDB (http://www.percona.com)  5.6.22-72.0 started; log sequence number 1602572
151206  8:24:31 [Note] Server socket created on IP: '127.0.0.1'.

推荐答案

主要是由于端口被阻止.默认 MySql 在端口 3306 上运行.

Mostly its due to blocked ports. By Default MySql run on port 3306.

检查哪个应用程序正在使用端口3306

Check which application is using port 3306

在 Xampp >单击 NetStat 它将显示所有具有运行端口的应用程序.

In Xampp > Click NetStat it will show you all application with there running ports.

一旦您找到在端口 3306 上运行的应用程序.杀死(关闭)该应用程序并尝试启动 MySql 现在它应该可以正常工作了.

Once you find which application is running on port 3306. Kill(close) that application and try starting MySql now it should now work fine.

如果您需要其他应用程序(使用端口 3306)，请确保 Mysql 首先启动，以便其他应用程序找到其他端口来启动.

If you need the other application(who was using port 3306) make sure Mysql start first so the other application find some other port to start.

如果此方法不起作用，只需更改 MySql

If this method doesn't work simply change the port for MySql

要更改MySql 端口 编辑line 1262 上的php.ini(您的可能不同)并更改MySql 端口 从 3306 到 0 到 65536 之间的任何数字，并确保这些端口未被任何其他应用程序使用

To change MySql port edit php.ini on line 1262(yours might be different) and change MySql port from 3306 to any number between 0 to 65536 and make sure these ports are not used by any other application

如果仍然无法正常工作，重新安装 xampp 可能有助于解决问题

If still not working re installation of xampp might help fix the problem

这篇关于Xampp 和 MySQL 未启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！