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

/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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值