首页新闻找找看学习计划

使用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 的权限也没用

呆呆兽-的主页 呆呆兽- | 菜鸟二级 | 园豆:203
提问于:2019-05-29 10:44
< >
分享
所有回答(2)
1

"he error means mysqld does not have the access rights to the directory.",目录的权限设置了

会长 | 园豆:5205 (大侠五级) | 2019-05-29 11:51

设置了 最高权限没用

支持(0) 反对(0) 呆呆兽- | 园豆:203 (菜鸟二级) | 2019-05-29 12:56
0

试试进入 ibdata1 文件夹执行命令 chown -R mysql:mysql .

dudu | 园豆:41311 (高人七级) | 2019-05-29 15:13
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册