mysql 没有在服务器启动时自动启动,但我可以手动启动,只要使用“/etc/init.d/mysql.server”以用户“mysql”身份登录,我在日志中收到的错误是
110809 9:16:21 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
所以我的问题是如何授予“root”和mysql start@boot的权限。
Note - ./ibdata1 and it's directory are own by mysql
提前感谢任何帮助。p.
答案1
您的 ibdata1 文件应归 拥有mysql
,并且可读写(600)
确保您的服务器正在以用户身份运行mysql
,如所述用户选项