linux mysql数据库启动失败日志 Plugin 'InnoDB' init function returned error.

小樱

1. tail -f /var/log/mysqld.log

复制代码

180613 00:25:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180613 00:28:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180613  0:28:02 [Warning] option 'table_definition_cache': unsigned value 200 adjusted to 256
180613  0:28:02 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib3fpNK3' (Errcode: 13)
180613  0:28:02  InnoDB: Error: unable to create temporary file; errno: 13
180613  0:28:02 [ERROR] Plugin 'InnoDB' init function returned error.
180613  0:28:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180613  0:28:02 [ERROR] /usr/libexec/mysqld: unknown variable 'performance_schema_max_table_instances=200'
180613  0:28:02 [ERROR] Aborting

网上搜索，全尼玛是错的，，什么删除ib_logfile0 ib_logfile1都是没有用的。

后来，，还是自己摸索了下，，看上面有个tmp报错？难道说是权限？

1. chmod 1777 /tmp

复制代码

给了1777后，发现tmp那行确实没抱错了，，但是数据库还是启动不起来。


通过寻找权限

1. find /var/lib/ -printf '%m %p\n'

复制代码

然后重置所有rpm包权限到默认值，，考虑慎用

1. for p in $(rpm -qa); do rpm --setperms $p; rpm --setugids $p; done

复制代码

还不行的话

1. mysqld_safe --skip-grant-table

复制代码

小樱

删除目录下的东西，mysql_install_db --user=mysql
暴力初始化。。

Doddyさま

把'/tmp/ib3fpNK3'删了再试试
还不行就检查一下是不是开启了SELINUX

小樱

Doddyさま 发表于 2018/6/13 21:20
把'/tmp/ib3fpNK3'删了再试试
还不行就检查一下是不是开启了SELINUX

已经好了，，他好像执行了chmod 000 -r /*被破坏权限了！帮他备份重装了

Doddyさま

小樱 发表于 2018/6/14 00:50
已经好了，，他好像执行了chmod 000 -r /*被破坏权限了！帮他备份重装了

实力作死...