【待反馈】MySQL数据库状态异常
刚安装的MySQL5.7，有问题，又卸载了重装，仍旧如此，请问什么问题？
您好，看错误日志，不是慢日志。 2024-06-25T06:24:33.844490Z 9 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 Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:35.838733Z 11 Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:39.083582Z 12 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 Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:42.053320Z 14 Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:24:44.335479Z 15 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 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 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 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 Access denied for user ＇root＇@＇localhost＇ (using password: YES)
2024-06-25T06:25:09.413866Z 21 Access denied for user ＇root＇@＇localhost＇ (using password: YES) GOQU 发表于 2024-6-25 14:27
2024-06-25T06:24:33.844490Z 9 InnoDB: Cannot open table /wp_commentmeta from the internal...
您好，根据您提供的日志信息来看的话，提到了innodb出现了故障
您可以参考 MySQL 官方文档中的 InnoDB 故障排除指南 (http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html) 来尝试解决这个问题。
以及使用root链接被拒绝
确保 root 用户的密码是正确的，您可以尝试重置 root 用户的密码并重新尝试连接数据库。
一般的重置方式没用了 查看一下是否有报错信息
cat /www/server/data/*.err|grep -i -C 10 error
检测一下文件是否为可执行权限
/www/server/mysql/bin/mysqld
页:
[1]