启动时数据库有问题已解决 悬赏5积分
之前好好的,然后我在服务器上装了个悬镜,不知道是否把数据库设置改了,现在禅道报错,以下是是错误日志
170509 09:58:41 mysqld_safe Starting mysqld daemon with databases from /opt/zbox/data/mysql
170509 9:58:41 [Warning] Ignoring user change to 'nobody' because the user was set to 'mysql' earlier on the command line
170509 9:58:41 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170509 9:58:41 [Warning] Ignoring user change to 'nobody' because the user was set to 'mysql' earlier on the command line
170509 9:58:41 [Note] /opt/zbox/run/mysql/mysqld (mysqld 5.5.45) starting as process 3172 ...
/opt/zbox/run/mysql/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
170509 9:58:41 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170509 9:58:41 InnoDB: The InnoDB memory heap is disabled
170509 9:58:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170509 9:58:41 InnoDB: Compressed tables use zlib 1.2.3.4
170509 9:58:41 InnoDB: Initializing buffer pool, size = 128.0M
170509 9:58:41 InnoDB: Completed initialization of buffer pool
170509 9:58:41 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: 'open'.
InnoDB: Cannot continue operation.
170509 09:58:41 mysqld_safe mysqld from pid file /opt/zbox/tmp/mysql/mysqld.pid ended
请问如何修复,里面有数据,数据需要保留
禅道版本:9.1.2
安装包类型:Linux安装包
操作系统:
客户端浏览器:
石洋洋
2017-05-09 10:47:18
ps -ef |grep mysql 检查一下mysql服务是否正常运行,重启一下禅道的服务再试一下。
回复
|