一旦启动 phpmyadmin XAMPP，MySQL 就会停止

Question

我在 XAMPP 中遇到 MySQL 启动但很快就停止的问题已经很长时间了。由于这个错误，我重新安装了 XAMPP 两次。上次重新安装后，我终于希望它现在可以正常工作了。已经工作了大约一周了，今天又出现同样的错误。我现在可以发现通过以管理员权限打开XAMPP并输入命令mysqld可以自动启动MySQL--skip-grant-tables在 XAMPP 外壳中。该命令实际上仅停止 phpmyadmin 的表。可能是表中有错误。然后我将 MySQL 安装为 Windows 服务以进行测试，并且必须发现 MySQL 可以毫无问题/命令输入地启动。但是，如果您想调用 phpmyadmin，则 phpmyadmin 上会出现错误消息，并且 MySQL 会自动停止。也许有人有解决问题的办法？phpmyadmin 错误消息：The connection could not be established due to invalid settings.  mysqli :: real_connect (): (HY000 / 2002): A connection could not be established because the target computer refused to connect.  Connection for the control user, as specified in your configuration, has failed.  mysqli :: real_connect (): (HY000 / 2002): A connection could not be established because the target computer refused to connect.  phpMyAdmin tried to connect to the MySQL server and the connection was rejected. You should check your host, user name and password settings in your config.inc.php and make sure that they correspond to the information you received from the administrator.

Answer 1

我想我能找到这个bug。正如我所怀疑的，这可能是由于桌子损坏造成的。现在再次检查 XAMPP 错误日志，发现以下错误。

2020-06-30 16:06:09 0 [ERROR] mysqld.exe: Table '. \ Mysql \ db' is marked as crashed and last (automatic?) Repair failed

2020-06-30 16:06:09 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '. \ Mysql \ db' is marked as crashed and last (automatic?) Repair failed

2020-06-30 16:06:09 0 [ERROR] aborting

意味着你必须修理桌子。刚刚又检查了一下。我认为这篇文章可以解决这个问题。