blocks|key|3598048|text|我获取问题来启动xampp服务"mysqld.exe:+Aria恢复失败。请在所有aria_chk表上运行aria_chk+-r并删除所有aria_log.########文件“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3598049|我删除xampp\mysql\data中的所有area_log文件|3598050|在此之后，我重新启动XAMPP，而不是它的工作。|3598051|谢谢|3598052|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I fetch the problem to start xampp services "mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files"

I delete all area_log files form xampp\mysql\data

after that I restart XAMPP than it works.

Thanks

blocks|key|2760422|text|检查MySQL的日志文件。您将在以下目录中找到它们:+C:\xampp\mysql\data+(假设xampp的标准安装位置)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2760423|还要检查是否没有其他程序或服务使用默认的MySql端口。您可以使用以下命令来完成这一任务：|2760424|netstat+-an+%7C+findstr+"3306"|code-block|syntax|javascript|2760425|如果出现任何情况，默认的mysql端口正在使用。|2760426|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Check the log files for MySQL. You will find them in this directory:
C:\xampp\mysql\data (assuming standard install location of xampp)

Also check if no other program or service uses the default MySql port. 
You can do this by using this command:

<pre><code>netstat -an | findstr "3306"
</code></pre>

If anything shows up the default mysql port is in use.

blocks|key|139877|text|在Windows中，您应该去:开始>运行>+services.msc+>Apache2.4>属性>开始模式>自动>应用>开始>确定>与MySQL相同|type|unstyled|depth|inlineStyleRanges|entityRanges|data|139878|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In Windows, you should go: Start > Run > services.msc > Apache 2.4 > Properties > Start Mode > Automatic > Apply > Start > OK > [Same as MySQL]

blocks|key|2760615|text|我无法在Mysql上启动xampp。错误信息是：-|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2760616|Aria恢复失败。请在所有Aria表上运行aria_chk+-r，并删除所有aria_log.########文件。插件'Aria‘init函数返回错误。插件“Aria”注册为存储引擎失败。插件“反馈”被禁用。Aria引擎未启用或未启动。必须启用Aria引擎才能继续使用mysqld配置了--+with+tmp-表。正在中止。
|blockquote|2760617|2760618|只需转到xampp/mysql/data，删除或删除与aria_log相关的文件，并重新启动xampp服务器。对我来说很好。|2760619|entityMap^0|4|5|C|5|0|0|0|4|G|R|8|1A|5|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|S|8|@]|D|@]|E|$]]|$1|I|3|-4|5|6|7|T|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|M|$]]

I was not able to start <code>Mysql</code> on <code>xampp</code>.
Error message was:-

<blockquote>
 Aria recovery failed. Please run aria_chk -r on all Aria tables and
 delete all aria_log.######## files. Plugin 'Aria' init function
 returned error. Plugin 'Aria' registration as a STORAGE ENGINE failed.
 Plugin 'FEEDBACK' is disabled. Aria engine is not enabled or did not
 start. The Aria engine must be enabled to continue as mysqld was
 configured with --with-aria-tmp-tables. Aborting.
</blockquote>

Just to go <code>xampp/mysql/data</code> and delete or remove the file related to <code>aria_log</code> and restart your <code>xampp</code> server.
Worked fine for me.

blocks|key|2760507|text|解决这个问题，在活动监视器中停止mysql进程，然后在xampp中重新启动mysql服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2760508|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Resolve the issue stopping the mysql process in the activity monitor and then restarting the mysql server from within the xampp UI.

blocks|key|139800|text|转到错误日志并检查。对于我来说，我得到了一条错误消息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|139801|InnoDB:+Error:无法打开单表表空间文件.\mysql\innodb_index_stats.ibd+InnoDB:我们不能继续崩溃恢复，因为如果不能将InnoDB日志中的日志记录应用到表中，表可能会变成InnoDB:损坏。InnoDB:若要修复该问题并启动mysqld:+InnoDB:+1)如果文件中存在权限问题而mysqld无法打开文件，则应修改权限。InnoDB:+2)如果不需要表，或者可以从备份中恢复表，那么可以删除.ibd文件，InnoDB将执行普通的InnoDB:崩溃恢复并忽略该表。InnoDB:+3)如果文件系统或磁盘出现故障，并且无法删除InnoDB：.ibd文件，则可以在my.cnf+InnoDB:中设置innodb_force_recovery+>0，并强制InnoDB在这里继续崩溃恢复。
|blockquote|139802|139803|所以我做的就是去mysql文件夹删除data1idb文件。从那以后一切都很顺利。当我安装Drupal时问题就开始了。|offset|length|style|CODE|139804|entityMap^0|0|0|0|I|8|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|O|8|@]|9|@]|A|$]]|$1|E|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@$H|R|I|S|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Go to the error log and check. For me I got this error message:

<blockquote>
 InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
 InnoDB: We do not continue the crash recovery, because the table may become
 InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
 InnoDB: To fix the problem and start mysqld:
 InnoDB: 1) If there is a permission problem in the file and mysqld cannot
 InnoDB: open the file, you should modify the permissions.
 InnoDB: 2) If the table is not needed, or you can restore it from a backup,
 InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
 InnoDB: crash recovery and ignore that table.
 InnoDB: 3) If the file system or the disk is broken, and you cannot remove
 InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
 InnoDB: and force InnoDB to continue crash recovery here.
</blockquote>

So what I did was I went to the mysql folder and deleted the <code>data1idb</code> file. After that it worked fine. The problem started when I installed Drupal.

blocks|key|139841|text|执行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|139842|which+mysql.server

sudo+path/to/mysql.server+start|code-block|syntax|javascript|139843|这应该适用于*nix操作系统。|139844|用于mac的sudo+/Applications/XAMPP/xamppfiles/bin/mysql.server+start|offset|length|style|CODE|139845|entityMap^0|0|0|0|6|1M|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Perform

<pre><code>which mysql.server

sudo path/to/mysql.server start
</code></pre>

This should work on *nix OS

eg <code>sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start</code> for mac osx

blocks|key|139771|text|在xampp文件夹中，您应该找到start+mysql批处理文件。运行它，防火墙可能会问你是否想让它通过(所以检查你的防火墙是否允许mysqld.exe通过)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|139772|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In The xampp folder you should find the start mysql batch file. Run it, The firewall might ask if you want to allow it through ( So check your firewall if it lets mysqld.exe through )

blocks|key|2760640|text|运行位于Xampp根目录中的"setup_xampp.bat“文件帮了我一个忙。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2760641|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Running the "setup_xampp.bat" file located in the root directory of Xampp did the trick for me.

blocks|key|3598150|text|虽然为时已晚，但我相信这会对未来的人有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3598151|首先运行which+mysql.server以了解mysql在计算机上的位置。然后运行sudo+/usr/local/bin/mysql.server+stop，以确保没有其他mysql进程正在运行。如果没有其他进程正在运行，则肯定会出现一个错误，即无法找到MySQL服务器PID文件！。这很好。|ordered-list-item|offset|length|style|CODE|BOLD|3598152|然后运行sudo+/Applications/XAMPP/xamppfiles/bin/mysql.server+start启动Xampp的mysql服务器。当您转到Xampp时，您应该会看到mysql状态是运行的。|3598153|3598154|3598155|请注意，这是为OS用户。|3598156|entityMap^0|0|4|I|17|11|3L|E|0|4|1M|2Y|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@$E|T|F|U|G|H]|$E|V|F|W|G|H]|$E|X|F|Y|G|I]]|9|@]|A|$]]|$1|J|3|K|5|D|7|Z|8|@$E|10|F|11|G|H]|$E|12|F|13|G|I]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|Q|$]]

Though this is late, I'm sure it would help someone in future.

<ol>
<li>First run <code>which mysql.server</code> to know where mysql is located on your machine. After then run <code>sudo /usr/local/bin/mysql.server stop</code>to be sure that no other mysql process is running. If no other process is running, you would definitely get an error saying MySQL server PID file could not be found!. That's fine.</li>
<li>After then run <code>sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start</code> to start Xampp's mysql server. When you go to the Xampp GUI, you should see that mysql status as running.</li>
</ol>

Please note that this is for OS X users.

blocks|key|2760659|text|我也面临着同样的问题。我在D驱动器上安装了xampp。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2760660|我以管理员身份卸载并安装安装程序。再次面临同样的问题。|2760661|我寻找并尝试了很多建议，但没有运气。|2760662|我通过右键单击xampp并打开管理员和xampp就可以解决这个问题。|2760663|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I face same issue. I installed xampp in D drive.
I uninstall and install setup as run as administrator. Again face same issue.
I searched and try lot of suggestion but no luck.
I solve the problem by right click on xampp and open as Administrator and xampp start working fine.

blocks|key|139998|text|我无法启动MySQL服务。当我检查mysql日志时，它说：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|139999|[ERROR]+mysqld:+File+'C:\xampp\mysql\data\aria_log_control'+not+found+(Errcode:+13+"Permission+denied")
[ERROR]+mysqld:+Got+error+'Can't+open+file'+when+trying+to+use+aria+control+file+'C:\xampp\mysql\data\aria_log_control'|code-block|syntax|javascript|140000|我检查了日志中建议的位置，文件就出现了。|140001|我发现我做了一个愚蠢的错误，因为UAC是在我的PC中激活的，所以我不得不使用“”启动XAMPP。|140002|对我来说挺好的。|140003|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I was not able to start MySQL service. When I checked mysql log it said:
<pre><code>[ERROR] mysqld: File 'C:\xampp\mysql\data\aria_log_control' not found (Errcode: 13 &quot;Permission denied&quot;)
[ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file 'C:\xampp\mysql\data\aria_log_control'
</code></pre>
I checked suggested location in the log and file was present.
I found I was doing silly mistake, Since UAC is activated in my PC, I had to start XAMPP using &quot;Run As Administrator&quot;.
It worked fine for me.

I have a problem with my XAMPP server. I can start Apache, FileZilla, and every thing else without problems, but when I try to start MySQL, it just says 

<blockquote>
 Attempting to start MySQL service...
</blockquote>

and it stays like that forever, like if it was frozen or something.

Any ideas how to fix it?

MySQL won't start on XAMPP server

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我的XAMPP服务器有问题。我可以无问题地启动Apache、FileZilla和其他任何东西，但当我尝试启动MySQL时，它只是这样写的。试图启动MySQL服务..。它永远都是这样的，就像它被冻结了什么的。有什么办法解决吗？

问MySQL不会在XAMPP服务器上启动
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL不会在XAMPP服务器上启动EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL不会在XAMPP服务器上启动
EN