已解决 启动时数据库有问题

之前好好的,然后我在服务器上装了个悬镜,不知道是否把数据库设置改了,现在禅道报错,以下是是错误日志

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安装包
操作系统
客户端浏览器

提问者: 张军 悬赏:5 日期: 2017-05-09 10:07:36 答案:1 点击:2580

获取技术支持

QQ: 电话:
设置备注
答案列表
2017/05/09
ps -ef |grep mysql  检查一下mysql服务是否正常运行,重启一下禅道的服务再试一下。
2017/05/09
[root@iZ11kovthqfZ ~]# /opt/zbox/zbox restart
Retart Apache success
ERROR! MySQL server is not running!
Restart Mysql fail. You can see the log /opt/zbox/logs/mysql_error.log
[root@iZ11kovthqfZ ~]# ps -ef | grep mysql
root 30331 1 0 11:43 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/mysql.pid
mysql 31210 30331 0 11:43 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/data/mysql/mysql.pid --socket=/tmp/mysql.sock --port=3306
root 32539 24010 0 11:43 pts/0 00:00:00 grep mysql
[root@iZ11kovthqfZ ~]#
2017/05/09
已经在群里回复。