mysql 无法写文件_MySQL 5.7安装错误`mysqld：无法创建/写入文件’/ var / lib / mysql / is_writable’...

最新推荐文章于 2024-03-07 09:30:14 发布
最新推荐文章于 2024-03-07 09:30:14 发布
阅读量1.1k 收藏
点赞数
文章标签： mysql 无法写文件
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_34378978/article/details/114802131
版权

我想在Ubuntu 14.04上安装MySQL 5.7.

以下是我遵循的步骤：

rm -rf /var/lib/mysql

mkdir -p /var/lib/mysql

cd

wget http://dev.mysql.com/get/mysql-apt-config_0.7.2-1_all.deb

dpkg -i mysql-apt-config_0.7.2-1_all.deb

apt-get update

apt-get -y install mysql-server

除最后一步外,所有步骤都完美无缺.它给了我以下错误：

mysqld: Can't create/write to file '/var/lib/mysql/is_writable' (Errcode: 13 - Permission denied)

2016-05-10T02:10:24.219279Z 0 [ERROR] --initialize specified but the data directory exists and is not writable. Aborting.

2016-05-10T02:10:24.219530Z 0 [ERROR] Aborting

以下是错误的完整日志：

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

apparmor libaio1 libapparmor-perl libapparmor1 libmecab2 mysql-client

mysql-common mysql-community-client mysql-community-server psmisc

Suggested packages:

apparmor-profiles apparmor-docs apparmor-utils

The following NEW packages will be installed:

apparmor libaio1 libapparmor-perl libapparmor1 libmecab2 mysql-client

mysql-common mysql-community-client mysql-community-server mysql-server

psmisc

0 upgraded, 11 newly installed, 0 to remove and 2 not upgraded.

Need to get 27.8 MB of archives.

After this operation, 215 MB of additional disk space will be used.

Get:1 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7 mysql-common amd64 5.7.12-1ubuntu14.04 [261 kB]

Get:2 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7 mysql-community-client amd64 5.7.12-1ubuntu14.04 [7307 kB]

Get:3 http://archive.ubuntu.com/ubuntu/ trusty/main libaio1 amd64 0.3.109-4 [6364 B]

Get:4 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7 mysql-client amd64 5.7.12-1ubuntu14.04 [12.4 kB]

Get:5 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7 mysql-community-server amd64 5.7.12-1ubuntu14.04 [19.5 MB]

Get:6 http://archive.ubuntu.com/ubuntu/ trusty-updates/main libapparmor1 amd64 2.8.95~2430-0ubuntu5.3 [25.5 kB]

Get:7 http://archive.ubuntu.com/ubuntu/ trusty-updates/main libapparmor-perl amd64 2.8.95~2430-0ubuntu5.3 [26.8 kB]

Get:8 http://archive.ubuntu.com/ubuntu/ trusty-updates/main apparmor amd64 2.8.95~2430-0ubuntu5.3 [319 kB]

Get:9 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7 mysql-server amd64 5.7.12-1ubuntu14.04 [12.4 kB]

Get:10 http://archive.ubuntu.com/ubuntu/ trusty/main psmisc amd64 22.20-1ubuntu2 [53.2 kB]

Get:11 http://archive.ubuntu.com/ubuntu/ trusty/universe libmecab2 amd64 0.996-1.1 [244 kB]

Fetched 27.8 MB in 0s (35.1 MB/s)

Preconfiguring packages ...

Selecting previously unselected package libaio1:amd64.

(Reading database ... 21277 files and directories currently installed.)

Preparing to unpack .../libaio1_0.3.109-4_amd64.deb ...

Unpacking libaio1:amd64 (0.3.109-4) ...

Selecting previously unselected package mysql-common.

Preparing to unpack .../mysql-common_5.7.12-1ubuntu14.04_amd64.deb ...

Unpacking mysql-common (5.7.12-1ubuntu14.04) ...

Selecting previously unselected package mysql-community-client.

Preparing to unpack .../mysql-community-client_5.7.12-1ubuntu14.04_amd64.deb ...

Unpacking mysql-community-client (5.7.12-1ubuntu14.04) ...

Selecting previously unselected package mysql-client.

Preparing to unpack .../mysql-client_5.7.12-1ubuntu14.04_amd64.deb ...

Unpacking mysql-client (5.7.12-1ubuntu14.04) ...

Selecting previously unselected package libapparmor1:amd64.

Preparing to unpack .../libapparmor1_2.8.95~2430-0ubuntu5.3_amd64.deb ...

Unpacking libapparmor1:amd64 (2.8.95~2430-0ubuntu5.3) ...

Selecting previously unselected package libapparmor-perl.

Preparing to unpack .../libapparmor-perl_2.8.95~2430-0ubuntu5.3_amd64.deb ...

Unpacking libapparmor-perl (2.8.95~2430-0ubuntu5.3) ...

Selecting previously unselected package apparmor.

Preparing to unpack .../apparmor_2.8.95~2430-0ubuntu5.3_amd64.deb ...

Unpacking apparmor (2.8.95~2430-0ubuntu5.3) ...

Selecting previously unselected package psmisc.

Preparing to unpack .../psmisc_22.20-1ubuntu2_amd64.deb ...

Unpacking psmisc (22.20-1ubuntu2) ...

Selecting previously unselected package libmecab2.

Preparing to unpack .../libmecab2_0.996-1.1_amd64.deb ...

Unpacking libmecab2 (0.996-1.1) ...

Selecting previously unselected package mysql-community-server.

Preparing to unpack .../mysql-community-server_5.7.12-1ubuntu14.04_amd64.deb ...

Unpacking mysql-community-server (5.7.12-1ubuntu14.04) ...

Selecting previously unselected package mysql-server.

Preparing to unpack .../mysql-server_5.7.12-1ubuntu14.04_amd64.deb ...

Unpacking mysql-server (5.7.12-1ubuntu14.04) ...

Processing triggers for ureadahead (0.100.0-16) ...

Setting up libaio1:amd64 (0.3.109-4) ...

Setting up mysql-common (5.7.12-1ubuntu14.04) ...

Setting up mysql-community-client (5.7.12-1ubuntu14.04) ...

Setting up mysql-client (5.7.12-1ubuntu14.04) ...

Setting up libapparmor1:amd64 (2.8.95~2430-0ubuntu5.3) ...

Setting up libapparmor-perl (2.8.95~2430-0ubuntu5.3) ...

Setting up apparmor (2.8.95~2430-0ubuntu5.3) ...

invoke-rc.d: policy-rc.d denied execution of start.

invoke-rc.d: policy-rc.d denied execution of reload.

Setting up psmisc (22.20-1ubuntu2) ...

Setting up libmecab2 (0.996-1.1) ...

Processing triggers for ureadahead (0.100.0-16) ...

Setting up mysql-community-server (5.7.12-1ubuntu14.04) ...

mysqld: Can't create/write to file '/var/lib/mysql/is_writable' (Errcode: 13 - Permission denied)

2016-05-10T02:10:24.219279Z 0 [ERROR] --initialize specified but the data directory exists and is not writable. Aborting.

2016-05-10T02:10:24.219530Z 0 [ERROR] Aborting

dpkg: error processing package mysql-community-server (--configure):

subprocess installed post-installation script returned error exit status 1

dpkg: dependency problems prevent configuration of mysql-server:

mysql-server depends on mysql-community-server (= 5.7.12-1ubuntu14.04); however:

Package mysql-community-server is not configured yet.

dpkg: error processing package mysql-server (--configure):

dependency problems - leaving unconfigured

Processing triggers for libc-bin (2.19-0ubuntu6.7) ...

Processing triggers for ureadahead (0.100.0-16) ...

Errors were encountered while processing:

mysql-community-server

mysql-server

E: Sub-process /usr/bin/dpkg returned an error code (1)

有人可以建议我一个错误的解决方案吗？

提前致谢！

最佳答案:

您需要确保您的数据目录由mysql用户拥有并且属于mysql组.在设置MySQL之前我也忘了这么做.如果你这样做,它应该工作：

sudo chown mysql /var/lib/mysql

sudo chgrp mysql /var/lib/mysql

标签：mysql

来源： https://codeday.me/bug/20190516/1115554.html

祈盟
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Linux bash：./xxx：无法执行二进制文件报错
09-14
主要介绍了Linux bash：./xxx：无法执行二进制文件报错，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
mysql 5.7.x 所需mysqld.service文件
03-11
mysql 5.7.x 所需mysqld.service文件
ubuntu安装MySQL5.7
qq_64010732的博客
04-17 256
ubuntu源码快速安装MySQL5.7
Ubuntu出现dpkg: error processing package mysql-community-server (--configure):问题
wm9028的专栏
02-17 5240
Ubuntu出现dpkg: error processing package mysql-community-server (–configure):问题 无论使用 sudo apt upgrade 还是 sudo apt autoremove 问题依旧。 使用mysql deb包安装出错 sudo apt upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calc
MySQL临时表创建出错(OS errno 13 - Permission denied)
最新发布
姚远OracleACE的博客
03-07 800
发现权限不足，而且居然没有粘滞位（Sticky bit），粘滞位是Unix文件系统权限的一个旗标。最常见的用法在目录上设置粘滞位，如此以来，只有目录内文件的所有者或者root才可以删除或移动该文件。如果不为目录设置粘滞位，任何具有该目录写和执行权限的用户都可以删除和移动其中的文件。实际应用中，粘滞位一般用于/tmp目录，以防止普通用户删除或移动其他用户的文件。一个客户向我抱怨：在MySQL查询小表没有问题，查询大表出错，下面是他发给我的出错的部分截屏（客户的表名被我隐藏了）。
ubuntu系统安装mysql5.7.42问题
weixin_42564841的博客
07-21 784
ubuntu系统中安装mysql5.7.42
mysqld: Can‘t create/write to file ‘/var/lib/mysql/is_writable‘ (Errcode: 13 - Permission denied)
guanghuotainkong的博客
01-18 4708
root@ubuntu:haoke# docker logs percona Initializing database mysqld: Can't create/write to file '/var/lib/mysql/is_writable' (Errcode: 13 - Permission denied) 2021-01-12T11:54:53.387051Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Plea
Ubuntu下安装MySQL出错(dpkg: dependency problems prevent configuration of mysql-community-server)
K.Sun
03-02 1万+
安装MySQL最后一步，输入命令：sudo dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb输出：(Reading database ... 160146 files and directories currently installed.) Preparing to unpack mysql-c
/var/lib/mysql/is_writable_MySQL 5.7 installation error `mysqld: Can't create/write to file '/var/li...
weixin_34092535的博客
01-26 297
I am trying to install MySQL 5.7 on Ubuntu 14.04.Following are the steps I followed:rm -rf /var/lib/mysqlmkdir -p /var/lib/mysqlcdwget http://dev.mysql.com/get/mysql-apt-config_0.7.2-1_all.debdpkg -i ...
mysqld --initialize 错误：mysqld: Can‘t create/write to file ‘G: ool\mysql\data\is_writable‘
星宇的博客
06-02 6369
G:\tool\mysql\bin>mysqld --initialize mysqld: Can't create/write to file 'G: ool\mysql\data\is_writable' (Errcode: 2 - No such file or directory) 2021-06-02T04:01:42.535302Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use -.
mysql安装无法创建mysqld_MySQL 5.7安装错误`mysqld：无法创建/写入文件’/ var / lib / mysql / is_writable’...
weixin_35784370的博客
01-19 432
我想在Ubuntu 14.04上安装MySQL 5.7.以下是我遵循的步骤：rm -rf /var/lib/mysqlmkdir -p /var/lib/mysqlcdwget http://dev.mysql.com/get/mysql-apt-config_0.7.2-1_all.debdpkg -i mysql-apt-config_0.7.2-1_all.debapt-get update...
MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
热门推荐
ncafei的博客
02-02 2万+
http://www.android100.org/html/201406/19/27784.html 最近碰到一个 MySQL不能创建临时文件的错误，解决过程中学到一些知识，这里分享一下，希望对碰到类似问题的同学有所帮助~ 关于MySQL临时文件： 1、MySQL使用环境变量TMPDIR的值作为保存临时文件的目录的路径名。如果未设置TMPDIR，MySQL将
[安装mysql初始化报错]mysqld: Can‘t create/write to file ‘D: oftkeshe ools\mysql-5.7.16-winx64\data\is_writa
wwibc89的博客
08-26 1842
[安装mysql初始化报错]mysqld: Can't create/write to file 'D: oftkeshe ools\mysql-5.7.16-winx64\data\is_writa解决方法
MySQL 启动报错:File ./mysql-bin.index not found (Errcode: 13)
12-15
Linux下安装初始化完MySQL数据库之后，使用mysqld_safe启动mysql数据库，如下发现，启动失败 [root@SVNServer bin]# ./mysqld_safe –user=mysql& 或 [root@SVNServer bin]# /etc/init.d/mysqld start Starting ...
Linux下MySQL5.7.18二进制包安装教程（无默认配置文件my_default.cnf）
12-15
最新在学习MySQL，纯新手，对Linux了解的也不多，因为是下载的最新版的MySQL（MySQL5.7.18）二进制包，CentOS7.2下测试安装，方便以后折腾。 大概步骤如下，安装删除反复折腾了几遍，按照以下步骤，应该没啥问题了。...
/var/lib/mysql/is_writable_关于Docker官方CentOS镜像无法启动mysqld的总结
weixin_35318150的博客
02-15 187
很多童鞋反映，在Docker官方CentOS镜像中安装了Mysql server后，无法正常启动。无法正常启动表现为两种情况：1> 初始完数据库后，mysqld启动报错2> systemctl start mysqld或者service mysqld start报错首先重现一下现场。第一种情况一、启动CentOS镜像，安装Mysql Server注意，Docker官方CentOS镜像l...
is_writable() 函数
m0_37477061的博客
03-16 263
PHP is_writable() 函数 PHP Filesystem 函数 定义和用法 is_writable() 函数判断指定的文件是否可写
/var/lib/mysql/is_writable,Docker - 编写永久数据MySQL
weixin_33693600的博客
02-06 156
I can't seem to get MySQL data to persist if I run $ docker-compose down with the following .ymlversion: '2'services:# other servicesdata:container_name: flask_dataimage: mysql:latestvolumes:- /var/li...
/var/lib/mysql/is_writable_【已解决】Mac中mysqld去重新初始化mysql出错：mysqld Can’t create directory /usr/local/mys...
weixin_39756696的博客
03-03 504
折腾：期间，尝试在Mac本地中去重新初始化mysql数据库，结果出错：➜AliyunRdsMysql mysqld --initializemysqld: Can't create directory '/usr/local/mysql-5.7.22-macos10.13-x86_64/data/' (Errcode: 17 - File exists)2018-04-27T02:28:43....
给我翻译下下面的指令version: '3' networks: likeadmin: driver: bridge services: nginx: container_name: likeadmin-nginx image: nginx:1.23.1 restart: always depends_on: - "php" volumes: - ../server:/docker_php/server - ./config/nginx/conf.d:/etc/nginx/conf.d - ./log/nginx/logs:/logs networks: - likeadmin ports: - "80:80" php: container_name: likeadmin-php image: likeshop/php:8.0.22-fpm restart: always working_dir: /docker_php/server volumes: - ../server:/docker_php/server networks: - likeadmin ports: - "9000:9000" user: "1000:1000" mysql: container_name: likeadmin-mysql image: mysql:5.7.29 #X86架构 #image: amd64/mysql:5.7.29 #arm架构 restart: always environment: MYSQL_ROOT_PASSWORD: root volumes: - ./data/mysql5.7.29/lib:/var/lib/mysql - ./config/mysql/mysqld.cnf:/etc/mysql/my.cnf networks: - likeadmin ports: - "3306:3306" redis: container_name: likeadmin-redis image: redis:7.0.4 restart: always volumes: - ./data/redis:/data networks: - likeadmin ports: - "6379:6379" node: container_name: likeadmin-node image: node:14.18.1 restart: always volumes: - ../admin:/likeadmin_php/admin networks: - likeadmin tty: true working_dir: /likeadmin_php/admin ports: - "5173:5173"
06-03
- ./data/mysql5.7.29/lib:/var/lib/mysql - ./config/mysql/mysqld.cnf:/etc/mysql/my.cnf networks: # 网络 - likeadmin ports: # 端口绑定 - "3306:3306" redis: # redis服务 container_name: likeadmin-...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值