chengzui 2017-04-21 15:13 采纳率: 13.3%
浏览 3319

虚拟机centos7上装MySQL5.7.18出现的问题

运行:systemctl start mysqld
错误:Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
mysqld.log中的提示:
2017-04-19T15:20:26.718566Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2017-04-19T15:20:26.718643Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2017-04-19T15:20:26.718655Z 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions
2017-04-19T15:20:26.718728Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-04-19T15:20:28.189585Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-04-19T15:20:28.189678Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-04-19T15:20:28.189696Z 0 [ERROR] Failed to initialize plugins.
2017-04-19T15:20:28.189708Z 0 [ERROR] Aborting

2017-04-19T15:20:28.189763Z 0 [Note] Binlog end
2017-04-19T15:20:28.192297Z 0 [Note] Shutting down plugin 'CSV'
2017-04-19T15:20:28.194679Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-04-19T15:20:31.320424Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-19T15:20:31.323827Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2017-04-19T15:20:31.323949Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18) starting as process 69981 ...

  • 写回答

1条回答

  • oyljerry 2017-04-22 01:13
    关注

    用sudo权限执行命令systemctl

    评论

报告相同问题?

悬赏问题

  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题
  • ¥15 Python时间序列如何拟合疏系数模型