启动mysql报错Can't find file: './mysql/plugin.frm'
来源:互联网 发布:怎么看oracle的端口号 编辑:程序博客网 时间:2024/05/22 00:23
启动mysql报错Can't find file: './mysql/plugin.frm'
171122 19:08:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171122 19:08:18 [Note] Server socket created on IP: '0.0.0.0'.
171122 19:08:18 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
171122 19:08:18 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
解决方法:
重启mysql以后突然报错,详情如下:
171122 19:08:18 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)171122 19:08:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171122 19:08:18 [Note] Server socket created on IP: '0.0.0.0'.
171122 19:08:18 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
171122 19:08:18 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
解决方法:
进入plugin.frm所在目录,我的是在
/var/lib/mysql/mysql
ls -l
发现所有文件的权限不知何故都变成root了,执行下面命令,修改权限为mysql
chown mysql.mysql *
阅读全文
0 0
- 启动mysql报错Can't find file: './mysql/plugin.frm'
- Can't find file: './mysql/plugin.frm'
- Can’t find file mysql/host.frm
- Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
- MySQL的坑 Can't find file: './mysql/plugin.frm' 问题
- MySQL的坑 Can't find file: './mysql/plugin.frm' 问题
- /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
- mysql Can't find file: './mysql/host.frm'
- Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
- mysql Can't open file: 'xx.frm' (errno: 24) 报错
- Mysql ERROR 1017 (HY000): Can't find file: './db/table.frm' (errno: 13)
- mysql ERROR 1017 :Can't find file: '/xxx.frm'...错误的解决方法
- mac os mysql启动报错 Can't open the mysql.plugin table
- mysql无法启动,报错 Can't start server: can't create PID file: No space left on device
- mysql启动不了,报错“[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it”
- MYSQL启动错误Can't open the mysql.plugin table
- mysql 启动报错 /usr/local/mysql//libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid'
- mysql启动报错Can't read from messagefile处理
- 三子棋
- ROS_Dynamic Reconfig 动态参数调节
- 数据结构总结1-算法设计技巧
- Login登录
- GitLab项目迁移到Gerrit
- 启动mysql报错Can't find file: './mysql/plugin.frm'
- Java冒泡排序
- 取余运算规则
- lang包源码解读之ProcessBuilder
- 查看手机进程oom_adj值
- 6.11
- HDU 5410 CRB and His Birthday
- Retrofit请求数据 多线程下载 Ijkplayer视频播放
- 牛客网PAT题目1002——数字分类(Java)