文档章节

mysql运行时报错,“Can't open the mysql.plugin table”

ArlenXu
 ArlenXu
发布于 2017/06/30 16:08
字数 419
阅读 138
收藏 0

/httx/run/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2017-06-30 16:04:49 7571 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-06-30 16:04:49 7571 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-06-30 16:04:49 7571 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-30 16:04:49 7571 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-30 16:04:49 7571 [Note] InnoDB: Memory barrier is not used
2017-06-30 16:04:49 7571 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-30 16:04:49 7571 [Note] InnoDB: Using Linux native AIO
2017-06-30 16:04:49 7571 [Note] InnoDB: Not using CPU crc32 instructions
2017-06-30 16:04:49 7571 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-06-30 16:04:49 7571 [Note] InnoDB: Completed initialization of buffer pool
2017-06-30 16:04:49 7571 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-30 16:04:49 7f2c2f2ab720  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.
2017-06-30 16:04:49 7571 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-06-30 16:04:49 7571 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored.
2017-06-30 16:04:49 7f2c2f2ab720  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.
2017-06-30 16:04:49 7571 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_table_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-06-30 16:04:49 7571 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_table_stats"', ignored.
2017-06-30 16:04:49 7f2c2f2ab720  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to

 

解决方法是:在运行初始化权限表的时候使用增加参数--datadir ,命令格式为: shell> ..../mysql_install_db --user=mysql --datadir=/usr/local/mysql/var

© 著作权归作者所有

ArlenXu
粉丝 14
博文 109
码字总数 70492
作品 0
杭州
后端工程师
私信 提问

暂无文章

反编译9.png图片还原

本文链接:https://blog.csdn.net/a1140778530/article/details/10528507 经常反编译apk文件找资源,9.png的文件处理起来很麻烦。 最近使用Ant自动编译打包app时,从别处搜罗来的9.png文件导...

shzwork
13分钟前
2
0
Shell脚本应用 – for、while循环语句

一、for循环语句 在实际工作中,经常会遇到某项任务需要多次执行的情况,而每次执行时仅仅是处理的对象不一样,其他命令相同。例如:根据通讯录中的姓名列表创建系统账号等情况。 当面对各种...

linux-tao
13分钟前
3
0
RPA风潮下企业财务工作模式的变革

RPA(机器人流程自动化)在财务领域的应用,正给企业财务带来前所未有的改变。 前RPA时代,财务领域面临的痛点 在RPA机器人应用之前,企业财务工作进程的推进,主要通过财务人员人工操作或信...

UiBot
18分钟前
3
0
Hive之命令行修改表注释

最近遇到一个需求,在不重建表的情况下,修改表的注释,hive有没有类似关系型数据库的SQL命令来修改呢,找了下,亲测有效,如下List-1 List-1 hive>use your_schemahvie>ALTER TABLE tabl...

克虏伯
18分钟前
3
0
是什么,它的作用是什么

在HTML文档的首部往往会有这么一句话<!DOCTYPE html>,许多时候我们忽视了它的存在,它实际上是一个声明,告诉浏览器用哪种HTML版本的规范来解读HTML文档。 尽管我们不给出这句声明浏览器照样...

前端老手
24分钟前
3
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部