使用systemd 配置多mysql 实例 无法启动
0
[待解决问题]
日志:
2019-05-29T02:31:47.615755Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: eeTOIi-/s1QP
2019-05-29T02:31:49.839603Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.16) initializing of server has completed
2019-05-29T02:31:54.260883Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 8091
2019-05-29T02:31:54.330425Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation.
2019-05-29T02:31:54.331038Z 1 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.
2019-05-29T02:31:54.331113Z 1 [ERROR] [MY-012270] [InnoDB] os_file_get_status() failed on './ibdata1'. Can't determine file permissions
2019-05-29T02:31:54.331417Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2019-05-29T02:31:54.331772Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-05-29T02:31:54.331876Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-05-29T02:31:54.332866Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
2019-05-29T02:39:50.739421Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 8213
2019-05-29T02:39:50.780482Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation.
2019-05-29T02:39:50.780548Z 1 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.
2019-05-29T02:39:50.780803Z 1 [ERROR] [MY-012270] [InnoDB] os_file_get_status() failed on './ibdata1'. Can't determine file permissions
2019-05-29T02:39:50.828453Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2019-05-29T02:39:50.828749Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-05-29T02:39:50.852111Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-05-29T02:39:50.954120Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
os_file_get_status() failed on './ibdata1'. Can't determine file permissions
给这个文件赋 777 的权限也没用
所有回答(2)
1
"he error means mysqld does not have the access rights to the directory."，目录的权限设置了
设置了 最高权限没用
0
试试进入 ibdata1 文件夹执行命令 chown -R mysql:mysql .
