如何解决AMH面板提示'No such file or directory MySQL连接出错'无法登录问题？

Question

今天登录AMH面板的时候提示：

您当前系统无法正常工作，请点击链接排查解决：No such file or directory MySQL连接出错。

无法登录

我通过点击提示连接：https://amh.sh/search.htm?keyword=No%20such%20file%20or%20directory&e=1
根据上边的内容进行操作，均无法解决。

这是今天的错误日志：

2024-01-27 10:01:16 23430 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2024-01-27 10:01:16 23430 [Note] Plugin 'InnoDB' is disabled.
2024-01-27 10:01:16 23430 [Note] Plugin 'FEDERATED' is disabled.
2024-01-27 10:01:16 23430 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f4e4cf07-bcb7-11ee-8c20-00163ea4d769.
2024-01-27 10:01:16 23430 [Note] RSA private key file not found: /home/usrdata/mysql-5.6//private_key.pem. Some authentication plugins will not work.
2024-01-27 10:01:16 23430 [Note] RSA public key file not found: /home/usrdata/mysql-5.6//public_key.pem. Some authentication plugins will not work.
2024-01-27 10:01:16 23430 [Note] Event Scheduler: Loaded 0 events
2024-01-27 10:01:16 23430 [Note] /usr/local/mysql-5.6/bin/mysqld: ready for connections.
Version: '5.6.51-log'  socket: '/tmp/mysql-5.6.sock'  port: 0  Source distribution
2024-08-29 12:52:35 1913 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2024-08-29 12:52:35 1913 [Note] Plugin 'InnoDB' is disabled.
2024-08-29 12:52:35 1913 [Note] Plugin 'FEDERATED' is disabled.
2024-08-29 12:52:35 1913 [Note] Recovering after a crash using mysql-bin
2024-08-29 12:52:37 1913 [Note] RSA private key file not found: /home/usrdata/mysql-5.6//private_key.pem. Some authentication plugins will not work.
2024-08-29 12:52:37 1913 [Note] RSA public key file not found: /home/usrdata/mysql-5.6//public_key.pem. Some authentication plugins will not work.
2024-08-29 12:52:37 1913 [Note] Event Scheduler: Loaded 0 events
2024-08-29 12:52:37 1913 [Note] /usr/local/mysql-5.6/bin/mysqld: ready for connections.
Version: '5.6.51-log'  socket: '/tmp/mysql-5.6.sock'  port: 0  Source distribution
2024-09-03 16:23:53 1902 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2024-09-03 16:23:53 1902 [Note] Plugin 'InnoDB' is disabled.
2024-09-03 16:23:53 1902 [Note] Plugin 'FEDERATED' is disabled.
2024-09-03 16:23:53 1902 [Note] Recovering after a crash using mysql-bin
2024-09-03 16:23:53 1902 [Note] RSA private key file not found: /home/usrdata/mysql-5.6//private_key.pem. Some authentication plugins will not work.
2024-09-03 16:23:53 1902 [Note] RSA public key file not found: /home/usrdata/mysql-5.6//public_key.pem. Some authentication plugins will not work.
2024-09-03 16:23:53 1902 [Note] Event Scheduler: Loaded 0 events
2024-09-03 16:23:53 1902 [Note] /usr/local/mysql-5.6/bin/mysqld: ready for connections.
Version: '5.6.51-log'  socket: '/tmp/mysql-5.6.sock'  port: 0  Source distribution
2025-02-26 07:40:03 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 07:40:03 1902 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2025-02-26 07:50:01 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 07:50:01 1902 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2025-02-26 08:00:01 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 08:00:01 1902 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2025-02-26 08:10:01 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 08:10:01 1902 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2025-02-26 08:20:01 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 08:20:01 1902 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2025-02-26 08:30:01 1902 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2025-02-26 08:30:01 1902 [Warning] Retry in 60 secs. Messa

Answer 1

报错是磁盘已经用满的问题，提示的链接也有说到这点。

可以用以下命令删除mysql二进制日志，或删除其它不需要的文件磁盘有空间了，再启动mysql

rm -f /home/usrdata/mysql*/mysql-bin*;
amh mysql start;

也建议面板上安装amem监控异常等情况，避免磁盘用到100%等。