【待反馈】mysql数据库无法启动

日志如下：我应该如何修复：
InnoDB: for how to resolve the issue.
2023-05-20 22:04:51 24089 [Note] InnoDB: 128 rollback segment(s) are active.
2023-05-20 22:04:51 24089 [Note] InnoDB: Waiting for purge to start
2023-05-20 22:04:52 24089 [Note] InnoDB: 5.6.50 started; log sequence number 67381324300
2023-05-20 22:04:52 24089 [Note] Recovering after a crash using mysql-bin
2023-05-20 22:04:52 24089 [Note] Starting crash recovery...
2023-05-20 22:04:52 24089 [Note] Crash recovery finished.
2023-05-20 22:04:52 24089 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2023-05-20 22:04:52 24089 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2023-05-20 22:04:52 24089 [Note] Server hostname (bind-address): '*'; port: 3306
2023-05-20 22:04:52 24089 [Note] IPv6 is available.
2023-05-20 22:04:52 24089 [Note]   - '::' resolves to '::';
2023-05-20 22:04:52 24089 [Note] Server socket created on IP: '::'.
2023-05-20 22:04:52 24089 [ERROR] /www/server/mysql/bin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
2023-05-20 22:04:52 24089 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired


mysql5.6打算升级5.7，然后就停止升级后，数据库就无法启动了，大佬帮我看看，我应该如何处理？感谢！

您好，请问您是如何升级您的mysql的呢？宝塔面板上升级mysql的话是需要删除数据库的，不支持直接在线升级的，您这个错误提示了是您当前数据库的user表出现错误了，建议您可以尝试搜索第三方教程来进行一个数据库的user表修复。数据库升级属于危险操作，建议您操作前做好相应的备份，谢谢！

我看到提示说要删除数据库，就停止了操作，然后就启动不了数据库了。请问怎么进行数据库的user表修复？

问题已经解决，多谢

宝塔用户_vvtmbw 发表于 2023-5-21 13:17
问题已经解决，多谢

你倒是分享一下怎么解决的啊

宝塔用户_vvtmbw 发表于 2023-5-21 13:17
问题已经解决，多谢

老兄怎么解决的？我现在遇到同样问题