升级Ubuntu 18.04到22.04后安装MySQL Server 8.0遇权限及表格式错误求助
升级Ubuntu 18.04到22.04后安装MySQL Server 8.0遇权限及表格式错误求助
我无法在本地机器上安装最新的MySQL Server。之前升级系统(Nginx/PhpMyAdmin等)一切正常,但升级过程中似乎删除了一些东西(可能不该用autoremove命令),所以我决定重新安装缺失的组件,但MySQL Server安装失败了——不管是升级还是全新安装都不行。
我执行的安装命令是:
sudo apt install mysql-server
终端输出如下:
Setting up mysql-server-8.0 (8.0.35-0ubuntu0.22.04.1) ... Renaming removed key_buffer and myisam-recover options (if present) Cannot stat file /proc/4090/fd/4: Permission denied Cannot stat file /proc/4090/fd/5: Permission denied Cannot stat file /proc/4090/fd/6: Permission denied Cannot stat file /proc/4090/fd/7: Permission denied Cannot stat file /proc/4090/fd/8: Permission denied Cannot stat file /proc/4090/fd/9: Permission denied Cannot stat file /proc/4090/fd/10: Permission denied Cannot stat file /proc/4090/fd/11: Permission denied Cannot stat file /proc/4090/fd/12: Permission denied Cannot stat file /proc/4090/fd/13: Permission denied Cannot stat file /proc/4090/fd/14: Permission denied Cannot stat file /proc/4090/fd/15: Permission denied Cannot stat file /proc/4090/fd/16: Permission denied Cannot stat file /proc/4090/fd/17: Permission denied Cannot stat file /proc/4090/fd/18: Permission denied Cannot stat file /proc/4090/fd/19: Permission denied Cannot stat file /proc/4090/fd/20: Permission denied Cannot stat file /proc/4090/fd/21: Permission denied Cannot stat file /proc/4090/fd/22: Permission denied Cannot stat file /proc/4090/fd/23: Permission denied Cannot stat file /proc/4090/fd/24: Permission denied Cannot stat file /proc/4090/fd/25: Permission denied Cannot stat file /proc/4090/fd/26: Permission denied Cannot stat file /proc/4090/fd/27: Permission denied Cannot stat file /proc/4090/fd/28: Permission denied Cannot stat file /proc/4090/fd/29: Permission denied Cannot stat file /proc/4090/fd/30: Permission denied Cannot stat file /proc/4090/fd/31: Permission denied Cannot stat file /proc/4090/fd/32: Permission denied Cannot stat file /proc/4090/fd/33: Permission denied Cannot stat file /proc/4090/fd/34: Permission denied Cannot stat file /proc/4090/fd/35: Permission denied Cannot stat file /proc/4090/fd/36: Permission denied Cannot stat file /proc/4090/fd/37: Permission denied Cannot stat file /proc/4090/fd/38: Permission denied Cannot stat file /proc/4090/fd/39: Permission denied Cannot stat file /proc/4090/fd/40: Permission denied Cannot stat file /proc/4090/fd/41: Permission denied Cannot stat file /proc/4090/fd/42: Permission denied Cannot stat file /proc/4090/fd/43: Permission denied Cannot stat file /proc/4090/fd/1023: Permission denied mysqld will log errors to /var/log/mysql/error.log 2023-12-28T13:01:54.636853Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log. Warning: Unable to start the server.
错误日志内容:
2023-12-28T13:01:40.717530Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu). 2023-12-28T13:01:41.366417Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 76570 2023-12-28T13:01:41.378633Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-12-28T13:01:41.756148Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-12-28T13:01:42.736322Z 4 [System] [MY-013381] [Server] Server upgrade from '50700' to '80035' started. 2023-12-28T13:01:54.633654Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'PREPARE stmt FROM @str; ' failed with error code = 130, error message = 'Incorrect file format 'db''. 2023-12-28T13:01:54.636731Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server. 2023-12-28T13:01:54.636750Z 0 [ERROR] [MY-010119] [Server] Aborting
现在想请教大家:
- 有没有办法解决这个问题?
- 错误提示说
db表格式不正确,这个表是什么?
谢谢各位的帮助,非常感激!
Cheers.
备注:内容来源于stack exchange,提问作者xaoo xaoo
相关产品推荐
相关产品推荐

