`

重启服务器出现Can't find file: './mysql/plugin.frm' 和 Unknown table engine 'InnoDB'

 
阅读更多

      日志分析的kettle跑批无故变慢,分析了多种情况后没有解决问题。决定重启服务器,重启服务器后,发现上面的mysql数据库启动不了,提示如下:  /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)

110222 11:15:07 mysqld_safe Starting mysqld daemon with databases from /home/mysql
110222 11:15:07 [Warning] Can't create test file /home/mysql/localhost.lower-test
110222 11:15:07 [Warning] Can't create test file /home/mysql/localhost.lower-test
 /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110222 11:15:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110222 11:15:07  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.
110222 11:15:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 解决方法如下:

#在终端中先输入下面这一行

chown -R mysql:mysql /home/data/mysql
#在输入下面的一行就OK了

chcon -R -t mysqld_db_t /home/mysql

#重启下MYSQL试试~

 

     重启mysql是OK了,但是访问数据库表的时候提示:Unknown table engine 'InnoDB',用了网上各种方法,修改了my.cnf N次,都没有解决。最后把防火墙关闭了setenforce 0,数据能正常访问。

     百度了一下,还是没理解防火墙和innodb有什么关系?记录一下该问题,为后面遇见这种问题的提供一个解决方案。

 

分享到:
评论

相关推荐

    MySQL中报错:Can’t find file: ‘./mysql/plugin.frm’的解决方法

    在MySQL数据库操作中,有时会遇到“Can't find file: './mysql/plugin.frm'”这样的错误,这通常意味着系统无法找到或访问特定的数据库表文件。这个错误可能由多种原因引起,包括但不限于文件权限问题、数据目录迁移...

    ultrafunk3插件

    若侵犯版权,请在腾讯微博里收听5sing笨笨郎 http://t.qq.com/benbenlang725 联系删除。 Cooledit2.1视频安装教程下载地址:http://www.5sing.com/help/images/soft/CoolEditPro.rar 中文版Cooledit2.1使用图文...

    mysql服务启动问题

    - `0904179:02:55 [ERROR] Unknown/unsupported table type: INNODB` - `0904179:02:55 [ERROR] Aborting` 这些错误信息表明InnoDB引擎在启动过程中遇到了问题,无法创建所需的临时文件。这通常是由于缺少临时文件...

    Python IED工具-- Pycharm 2020.1 安装中文语言插件zh.201.7.jar

    2.打开中文插件的下载地址(https://plugins.jetbrains.com/plugin/13710-chinese-simplified-language-pack-eap/versions) 3.下载Pycharm对应版本(Pycharm2020.1社区版全中文,专业版有一些是英文目前只能下载zh....

    # jquery.cookie ![Build Status](https://travis-ci.org/carhartl/

    A simple, lightweight jQuery plugin for reading, writing and deleting cookies. ## Installation Include script *after* the jQuery library (unless you are packaging scripts somehow else): ...

    Android代码-jmh-gradle-plugin

    = JMH Gradle Plugin :jmh-version: 1.21 :plugin-version: 0.4.8 image:http://img.shields.io/travis/melix/jmh-gradle-plugin/master.svg["Build Status (travis)", link=...

    Maven更新失败,Cannot resolve plugin org.apache.maven.plugins:maven-compiler-plugin:3.1

    Maven更新问题 今天Maven在更新的时候发现一直更新不成功,总结下解决方法。 在apache-maven-3.5.2/conf/setting.xml中加入以下配置即可解决 alimaven aliyun maven ... central junit junit Address/ ...

    最新Color Admin1.9 - bootstrap3响应后台模板+前端网页模板

    Multiple File Upload Basic Table Managed Table 9 DataTables Plugins DataTables Extension Combination Flot Charts Morris Charts Chart JS Chart d3 Calendar Maps Gallery Gallery v2 Blank ...

    settings.xml

    public https://maven.aliyun.com/nexus/content/groups/public central仓和jcenter仓的聚合仓 google https://maven.aliyun.com/nexus/content/repositories/google gradle-plugin ...

    jenkins credentials-plugin1.11.hpi

    copy the resulting ./target/credentials.hpi file to the $JENKINS_HOME/plugins directory. Don't forget to restart Jenkins afterwards. 2. or use the plugin management console ...

    elasticsearch-shield-2.3.2.jar

    ./bin/plugin install license 2、再安装shield,执行以下命令: ./bin/plugin install shield 重启Elasticsearch 进入/ultra/ES/elasticsearch-2.3.4/bin下。 1、先查Elasticsearch的进程: ps–ef|grep ...

    如何更改MySQL数据库文件存放位置?解决Can't open the mysql.plugin table.start Job failed to start

    当遇到“Can't open the mysql.plugin table”这样的错误时,通常表明MySQL无法正常启动,可能与数据文件的位置有关。下面将详细介绍如何更改MySQL数据库文件存放位置以及解决“start Job failed to start”的问题。...

    qtcreator-ros-xenial-latest-offline-installer.run

    ros qtcreator plugin 离线安装包,外网下载速度很慢。 本篇博客主要用来记录ubuntu 16.04下配置ROS Qt Creator Plugin的过程。 https://blog.csdn.net/Bing_Lee/article/details/115221346

    Multiple SCMs Plugin 0.3 hpi

    copy the resulting ./target/credentials.hpi file to the $JENKINS_HOME/plugins directory. Don't forget to restart Jenkins afterwards. 2. or use the plugin management console ...

    cas licensing

    maven-license-plugin:1.9.0:check (default) on project cas-server-webapp: Resource E:\IDEAWork\test\hxyFrame\frame-casServer/src/licensing/header.txt not found in file system, classpath or URL: unknown...

    手动解决Cannot find module '@sentry/webpack-plugin'等问题

    解决Cannot find module '@sentry/webpack-plugin',Cannot find module '@sentry/browser',Cannot find module '@sentry/cli'等问题。<br/> 下载后,解压后文件夹,放在vue项目的node_modules文件夹下,即可。

    com.tencent.qqpimsecure.plugin.alice9000901.jar

    com.tencent.qqpimsecure.plugin.alice9000901.jar

    基于Java的Hotswap插件.zip

    Hotswap是一个免费、开源的Intellij Idea插件,通过这个插件可以实现热部署和流量重放的功能。 ## 安装 - 使用IDE内置的插件系统: <kbd>Settings/Preferences</kbd> > <kbd>Plugins</kbd> > <kbd>Marketplace</kbd...

Global site tag (gtag.js) - Google Analytics