一键安装包
4716

启动时数据库有问题已解决 悬赏5积分

提问者张军 答案数1 阅读数2687 发表时间2017-05-09 10:07:36

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

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服务是否正常运行,重启一下禅道的服务再试一下。
🍑
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
已经在群里回复。
联系我们
联系人
魏中显/高级客户经理
电话(微信)
18561939726
QQ号码
1746749398
联系邮箱
weizhongxian@chandao.com
返回顶部
魏中显
高级客户经理
18561939726
1746749398
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。