[ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions

最新推荐文章于 2023-06-04 23:36:56 发布
原创 最新推荐文章于 2023-06-04 23:36:56 发布 · 2.7k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #报错 #ibdata1

本文介绍如何进入MySQL的安装目录并修改data目录的权限，确保MySQL服务能够正确运行。通过改变目录所有者为mysql用户，可以避免因权限问题导致的服务启动失败。

进入 mysql 安装目录：

cd /usr/local/mysql

修改 data 目录权限：

chown -R mysql:mysql data/

 

mysql Unable to lock ./ibdata1, error: 11
03-27
标题“mysql Unable to lock ./ibdata1, error: 11”所反映的问题是MySQL数据库在运行过程中遇到了一个常见的错误，提示无法锁定数据文件`ibdata1`，错误代码11。这个错误通常与数据库的表空间管理、并发操作或者...
MySQL修改innodb_data_file_path参数的一些注意事项
09-09
在描述中提到的情况中，初始的`innodb_data_file_path`设置为`ibdata1:12M:autoextend`，这意味着`ibdata1`文件初始大小为12MB，并且可以自动扩展。当需要增大这个值，比如改为1GB，直接在配置文件中将12M改为1G会...
InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions【mysql5.7启动错误】
kouryoushine的博客
11-26 4030
错误信息 2019-11-26T08:17:13.609094Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-26T08:17:13.620110...
mysql重启失败报错ibdata1 Can't determine file permissions
Agonisq的博客
04-04 8673
[ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions mysql重启报错以上. 版本：mysql5.7+centos7.0 解决步骤： 1.查看配置文件内容指定的pid-file cat /etc/my.cnf pid-file=/var/...
Mysql:ibdata1 Can‘t determine file permissions
q195136130的专栏
06-04 599
一个小的故障处理
MySQL启动失败：os_file_get_status() failed on ‘./ibdata1‘
代码大兵
04-11 1682
在此这前，我对SELinux完全不了解。
mysql ibdata1 损坏_MySQL无法启动-ibdata1损坏了吗？ -操作系统错误编号13-权限问题...
weixin_32093519的博客
01-19 255
Server shutdown from power failure.Mysql will not start now.Disk is not full.Syslog is belowOct 11 15:03:31 joe mysqld_safe[24757]: startedOct 11 15:03:31 joe mysqld[24760]: 101011 15:03:31 InnoDB: O...
MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error
01-21
016-03-03T00:02:30.483037Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35 2016-03-03T00:02:30.483100Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same ...
mysql ibdata1 mode_mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
weixin_42394573的博客
01-18 484
最近开始研究mysql，有一台服务器，第一次部署时有一些配置文件的路径有问题，打算重新部署，因为mysql用的二进制安装方式，删除了mysql目录，重新部署是报错：# ./scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysqlInstalling MySQL system tables...2015-05-29 11:1...
ibdata1文件损坏时恢复InnoDB单表测试
diankuozhi9810的博客
08-03 548
Preface ibdata1 file is a shared system tablespace of innodb engine.Although we always set variable of "innodb_file_per_table" to "on" which means put the data of table into their indi...
mysql启动不了的问题
juane的专栏
01-29 1392
mysql重启失败报错ibdata1 Can't determine file permissions  [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions mysql重启报错以上. 版本：mysql5.7+centos7.0 解决步骤：     1.查看...
MySQLのIbdata1异常及恢复
ys1109的专栏
12-05 8124
MySQLのIbdata1异常及恢复 环境:CentOS5.4/MySQL-5.1.48 1.将优化后的my.cnf替换旧的my.cnf,导致MySQLd无法启动 err文件提示如下: InnoDB: Error: auto-extending data file /data/mysqldata/innodb/data/ibdata1 is of a different size I
mysql ibdata损坏_完美解决mysql启动后随即关闭的问题（ibdata1文件损坏导致）
weixin_30866939的博客
01-20 656
机房一台服务器上的mysql运行一段时间了，突然出现了一个很奇怪的现象：重启后无法恢复了！准确情况是：启动mysql后随即就又关闭了。查看mysql错误日志如下：160920 22:41:41 mysqld_safe Starting mysqld daemon with databases from /home/MysqlData/2016-09-20 22:41:41 0 [Note] /Da...
mysql 备份0字节_mysql的备份恢复
weixin_36124750的博客
02-27 863
一、mysql的备份1、mysqldump逻辑备份，支持温备，热备，使用mysqldump完全备份，binlog增量备份mysqldump -utest -ptest -h192.168.0.204 test > database-date +'%Y-%m-%d'1)、备份innodb引擎的数据库时mysqldump --single-transaction --master-data=2...
[ERROR] InnoDB: Operating system error number 13 in a file operation
雅冰石的专栏
09-30 1367
一 问题描述 启动mariadb的时候报错： 2020-09-30 15:48:26 0 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied") 2020-09-30 15:48:26 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/l
centos系统修改MySQL默认存储路径导致无法启动的问题
hzy_5g的博客
04-23 7272
更改MySQL默认存储数据存储路径，需要先修改配置，再拷贝数据，然后重启。 1. 为了保证数据的准确性最好是停止mysql 服务，或者把mysql 表的写进行加锁。 mysqladmin-uroot-pshutdown 采用命令查询mysql进程：psaux|grepmysql|grep-vgrep所有有关mysql的进程都关掉了。 2、修改配置文件 /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/li...
systemd管理mysql多实例_使用systemd 配置多mysql 实例 无法启动
weixin_35079944的博客
01-19 162
日志:2019-05-29T02:31:47.615755Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: eeTOIi-/s1QP2019-05-29T02:31:49.839603Z 0 [System] [MY-013170] [Server] /usr/sbin/mys...
file permissions
weixin_33895604的博客
05-03 265
文件读写权限[root@localhost /]# ll /tmp/total 20drwx-w-r--. 2 root root 6 May 3 12:24 a1d-w-r----x. 2 root root 6 May 3 12:24 a2#ll或#ls -l 命令可查看到文件和文件夹权限，主要针对三类对象：owner，group，other总结了对应的...
2025-11-18T04:27:00.160647Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2025-11-18T04:27:00.160661Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2025-11-18T04:27:00.160664Z 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions 2025-11-18T04:27:00.160668Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2025-11-18T04:27:00.763265Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2025-11-18T04:27:00.763300Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-11-18T04:27:00.763307Z 0 [ERROR] Failed to initialize builtin plugins. 2025-11-18T04:27:00.763310Z 0 [ERROR] Aborting
最新发布
11-19
MySQL启动报错，出现InnoDB插件初始化失败、操作系统错误号13（表示无目录访问权限）以及无法确定文件权限等问题，可参考以下解决办法： 1. **检查磁盘空间**：确保磁盘有足够的空间供MySQL使用，可使用`df -f`命令来检查磁盘使用情况[^1]。 2. **查看日志**：查看MySQL日志文件，如`/var/log/mysqld.log`，从中获取详细的错误信息，以定位问题。示例如下： ```bash [root@localhost ~]# cat /var/log/mysqld.log ... 2020-03-13T18:53:16.099273Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2020-03-13T18:53:16.099347Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2020-03-13T18:53:16.099357Z 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions 2020-03-13T18:53:16.099369Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2020-03-13T18:53:16.718886Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2020-03-13T18:53:16.718953Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2020-03-13T18:53:16.718962Z 0 [ERROR] Failed to initialize builtin plugins. 2020-03-13T18:53:16.718966Z 0 [ERROR] Aborting ``` 3. **备份并修改SELinux配置**：备份SELinux配置文件，然后将SELinux设置为禁用状态。示例命令如下： ```bash [root@localhost ~]# cp -r /etc/selinux/config /etc/selinux/config.bak [root@localhost ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config [root@localhost ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted ```
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

dreamcode

你的鼓励是我创作的动力！

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值