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

Question

我在XAMPP中有很长一段时间的问题，MySQL启动但在短时间后停止。由于这个错误，我重新安装了XAMPP两次。在最后一次重装之后，我终于有了希望，它现在可以工作了。它已经工作了大约一周，今天也出现了同样的错误。我现在可以发现，通过使用管理员权限打开XAMPP并在XAMPP Shell中输入命令mysqld --skip-grant-tables，可以自动启动MySQL。该命令实际上只停止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

我想我能找到窃听器。正如我所怀疑的，这可能是因为桌子坏了。现在，我再次检查了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

意味着你必须修好桌子。刚刚又检查了一遍。我认为this post可以解决这个问题。