mysql - LINUX MINT mysql
问题描述
错误 LINUX MINT MYSQL
- 你能解释发生了什么吗?
- 我无法在 xampp 中启动
- 我应该更改什么配置?
我已经将 /var/lib/mysql/ 更改为 chmod 777
2019-02-27T16:35:55.748379Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-02-27T16:35:55.748447Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-02-27T16:35:55.919606Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-02-27T16:35:55.921605Z 0 [Note] mysqld (mysqld 5.7.25-0ubuntu0.18.04.2) starting as process 16788 ...
2019-02-27T16:35:55.926137Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-02-27T16:35:55.926173Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-27T16:35:55.926182Z 0 [Note] InnoDB: Uses event mutexes
2019-02-27T16:35:55.926190Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-02-27T16:35:55.926198Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-02-27T16:35:55.926206Z 0 [Note] InnoDB: Using Linux native AIO
2019-02-27T16:35:55.926511Z 0 [Note] InnoDB: Number of pools: 1
2019-02-27T16:35:55.926644Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-02-27T16:35:55.928888Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-02-27T16:35:55.945234Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-27T16:35:55.948312Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-02-27T16:35:55.958383Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-02-27T16:35:55.958517Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-02-27T16:35:55.958539Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-02-27T16:35:56.559302Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-02-27T16:35:56.559365Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-02-27T16:35:56.559381Z 0 [ERROR] Failed to initialize builtin plugins.
2019-02-27T16:35:56.559404Z 0 [ERROR] Aborting
2019-02-27T16:35:56.559441Z 0 [Note] Binlog end
2019-02-27T16:35:56.559583Z 0 [Note] Shutting down plugin 'CSV'
2019-02-27T16:35:56.560410Z 0 [Note] mysqld: Shutdown complete
解决方案
您必须检查文件系统的权限:
The innodb_system data file 'ibdata1' must be writable
mysql 用户似乎无法写入包含 ibdata1 的文件夹。
推荐阅读
- symfony - Raspbian / Mercure - 绑定:权限被拒绝
- flutter - 构建 OutputPage(dirty, dependencies: [_ModalScopeStatus]): Unexpected null value
- python - pyqt5窗口全屏不显示边框
- git - 将 repo 迁移到 Git LFS,现在克隆速度要慢得多
- python - 用自定义功能替换模块的功能
- postgresql - PostgreSQL 安装程序的签名(sha1、sha256、MD5 等)
- html - 在图像前的中心位置显示文本
- jmeter - 如何在 Jmeter 结果 .xml 文件中包含端点?
- reactjs - 'key' 属性在非动态子组件中是如何工作的,为什么它对于渲染更新很重要?
- python-3.x - 如何使用 opencv 和 tkinter 在 Python 中创建两个独立的窗口?