【待反馈】MySQL数据库状态异常

刚安装的MySQL5.7，有问题，又卸载了重装，仍旧如此，请问什么问题？

您好，看错误日志，不是慢日志。

2024-06-25T06:24:33.844490Z 9 [Warning] InnoDB: Cannot open table /wp_commentmeta from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:24:35.838149Z 10 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:35.838733Z 11 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:39.083582Z 12 [Warning] InnoDB: Cannot open table daoaction_com/mac_vod_search from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:24:42.052337Z 13 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:42.053320Z 14 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:44.335479Z 15 [Warning] InnoDB: Cannot open table ygdy_com/mac_vod_search from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:24:56.305848Z 16 [Warning] InnoDB: Cannot open table /fa_cms_channel from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:24:57.299324Z 17 [Warning] InnoDB: Cannot open table /fa_cms_channel from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:25:08.555619Z 19 [Warning] InnoDB: Cannot open table /fa_cms_channel from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2024-06-25T06:25:09.413325Z 20 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:25:09.413866Z 21 [Note] Access denied for user ＇root＇@＇localhost＇ (using password: YES)

GOQU 发表于 2024-6-25 14:27
2024-06-25T06:24:33.844490Z 9 [Warning] InnoDB: Cannot open table /wp_commentmeta from the internal  ...

您好，根据您提供的日志信息来看的话，提到了innodb出现了故障
您可以参考 MySQL 官方文档中的 InnoDB 故障排除指南 (http://dev.mysql.com/doc/refman/ ... roubleshooting.html) 来尝试解决这个问题。
以及使用root链接被拒绝

确保 root 用户的密码是正确的，您可以尝试重置 root 用户的密码并重新尝试连接数据库。

一般的重置方式没用了

查看一下是否有报错信息
cat /www/server/data/*.err|grep -i -C 10 error
检测一下文件是否为可执行权限
/www/server/mysql/bin/mysqld