日志分析的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'”这样的错误,这通常意味着系统无法找到或访问特定的数据库表文件。这个错误可能由多种原因引起,包括但不限于文件权限问题、数据目录迁移...
若侵犯版权,请在腾讯微博里收听5sing笨笨郎 http://t.qq.com/benbenlang725 联系删除。 Cooledit2.1视频安装教程下载地址:http://www.5sing.com/help/images/soft/CoolEditPro.rar 中文版Cooledit2.1使用图文...
- `0904179:02:55 [ERROR] Unknown/unsupported table type: INNODB` - `0904179:02:55 [ERROR] Aborting` 这些错误信息表明InnoDB引擎在启动过程中遇到了问题,无法创建所需的临时文件。这通常是由于缺少临时文件...
2.打开中文插件的下载地址(https://plugins.jetbrains.com/plugin/13710-chinese-simplified-language-pack-eap/versions) 3.下载Pycharm对应版本(Pycharm2020.1社区版全中文,专业版有一些是英文目前只能下载zh....
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): ...
= 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更新问题 今天Maven在更新的时候发现一直更新不成功,总结下解决方法。 在apache-maven-3.5.2/conf/setting.xml中加入以下配置即可解决 alimaven aliyun maven ... central junit junit Address/ ...
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 ...
public https://maven.aliyun.com/nexus/content/groups/public central仓和jcenter仓的聚合仓 google https://maven.aliyun.com/nexus/content/repositories/google gradle-plugin ...
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 ...
./bin/plugin install license 2、再安装shield,执行以下命令: ./bin/plugin install shield 重启Elasticsearch 进入/ultra/ES/elasticsearch-2.3.4/bin下。 1、先查Elasticsearch的进程: ps–ef|grep ...
当遇到“Can't open the mysql.plugin table”这样的错误时,通常表明MySQL无法正常启动,可能与数据文件的位置有关。下面将详细介绍如何更改MySQL数据库文件存放位置以及解决“start Job failed to start”的问题。...
ros qtcreator plugin 离线安装包,外网下载速度很慢。 本篇博客主要用来记录ubuntu 16.04下配置ROS Qt Creator Plugin的过程。 https://blog.csdn.net/Bing_Lee/article/details/115221346
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 ...
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/browser',Cannot find module '@sentry/cli'等问题。<br/> 下载后,解压后文件夹,放在vue项目的node_modules文件夹下,即可。
com.tencent.qqpimsecure.plugin.alice9000901.jar
Hotswap是一个免费、开源的Intellij Idea插件,通过这个插件可以实现热部署和流量重放的功能。 ## 安装 - 使用IDE内置的插件系统: <kbd>Settings/Preferences</kbd> > <kbd>Plugins</kbd> > <kbd>Marketplace</kbd...