mysql - LINUX MINT mysql

Question

Linux MINT MYSQL 错误

1. 您能解释一下发生了什么吗？
2. 我无法在 xampp 中启动
3. 我应该更改哪些配置？

我已经将/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

Answer 1

您必须检查文件系统的权限:

The innodb_system data file 'ibdata1' must be writable

mysql 用户似乎无法写入包含 ibdata1 的文件夹。