mysql启动报错：mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘

最新推荐文章于 2024-03-07 14:27:45 发布

小太阳ss

最新推荐文章于 2024-03-07 14:27:45 发布

阅读量1w

点赞数 9

分类专栏： Linux 文章标签： mysql linux

本文链接：https://blog.csdn.net/qq_41080112/article/details/110498132

版权

Linux 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log’, however file don’t exists.启动mysql出现这个错误

**原因：**

没有路径也没有权限，创建路径就可以解决了

[root@localhost ~]# mkdir /var/log/mariadb
[root@localhost ~]# touch /var/log/mariadb/mariadb.log
[root@localhost ~]# chown -R mysql:mysql /var/log/mariadb/
[root@localhost ~]# /usr/local/mysql/support-files/mysql.server start

就可以成功了
运行图

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

小太阳ss

关注关注

9
点赞
踩
14

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

mysql基础:mysqld_safe 启动执行流程详解

09-10

本篇文章是对mysql基础中的mysqld_safe启动执行流程进行了详细的分析介绍，需要的朋友参考下

mysql8启启动失败 mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘

qq_29653475的博客

11-17

1万+

Starting MySQL.2021-11-17T11:04:25.022108Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/data/mysql/data/localhost.local.

参与评论您还未登录，请先登录后发表或查看评论

mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘, however file don‘t exists. Creat

weixin_44895829的博客

03-06

3521

linux启动mysql时报错： mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql' 解决办法： yum list installed |grep mariadb 查看系统是否带mariadb数据库删除系统带的mariadb数据库，法令如下： [roo@bogon /]$ rpm -e ari

mysql-5.7.24安装出现mysql_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘,however file don‘t

qq_42807079的博客

12-10

1864

linux安装mysql出现mysql_safe error: log-error set to ‘/var/log/mariadb/mariadb.log’,however file don’t exists. create writable for user "mysql"错误表示： log文件不存在，需要创建该文件。该文件路径没有mysql权限，需要赋予权限。解决方法如下： # 创建目录 mkdir /var/log/mariadb # 创建log文件 touch /var/log/mari.

2.1 [手把手教你搭建] 之在linux上搭建mysql的常见问题（持续更新中）

许章正的博客

04-04

931

跟我一起解决linux环境下安装mysql可能遇到的问题

Starting MySQL. mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘,however file don‘

追求诗和远方的路上

11-16

2194

启动MySQL报错并解决： Starting MySQL.2023-11-16T06:24:39.857506Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log',however file don't exists. Create writable for user 'mysql'. The server quit without updating PID file (/var/lib/mysql/y[FAILED]d)

MySQL 启动报错:File ./mysql-bin.index not found (Errcode: 13)

09-10

MySQL数据库在启动时可能会遇到各种错误，其中一种常见的报错是"File ./mysql-bin.index not found (Errcode: 13)"。这个错误通常表明MySQL无法找到它的二进制日志索引文件（mysql-bin.index），并且错误代码13通常...

mysql安全启动脚本mysqld_safe详细介绍

12-15

然而，当从MySQL-Max升级到非-Max版本时，需要手动删除旧的mysqld-max，以确保mysqld_safe启动新版本的mysqld。 mysqld_safe支持多种启动选项，允许用户自定义服务器的行为。例如： - `-help`：显示帮助信息并退出...

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 ...

Linux安装MySQL时候出现log-error set to '/var/log/mariadb/mariadb.log', however file don't exists.

最新发布

weixin_44924238的博客

03-07

526

Create writable for user 'mysql'. The server quit without updating PID file (/usr/local/mysql[FAILED]sql.pid).

启动mysql报错mysqld_safe error: log-error set to /var/log/mariadb/mariadb.log

qq_34218345的博客

06-24

2万+

原因因为没有路径也没有权限，所以创建此路径并授权给mysql用户 mkdir /var/log/mariadb touch /var/log/mariadb/mariadb.log # 用户组及用户 chown -R mysql:mysql /var/log/mariadb/ /usr/local/mysql/support-files/mysql.server start ...

阿里云Linux下MySQL5.7.20安装

星空的专栏

12-05

1607

本机是64位，直接用命令安装 ps：https://dev.mysql.com/downloads/mysql/ 去网站看下最新的版本，修改下面命令 wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz 此处新建MySQL数据库用户及用户组，信

自定义目录安装mysql 报错集锦mysqld_safe error: log-error Please use --explicit_defaults_for_ --initialize speci

Muxiu

10-26

906

参考链接： 1. mysql8启启动失败 mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘2. 【[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_】3. MySQL [ERROR] --initialize specified but the data directory has

centos启动MySQL失败

Beyond_F4的博客

11-29

347

错误提示： mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log' 原因找不到日志文件或者日志文件不存在方法：创建该文件 mkdir/var/log/mariadb touch/var/log/mariadb/mariadb.log chown -R mysql:mysql/var/log/ma...

[root@localhost mysql]# ./support-files/mysql.server start Starting MySQL.2023-06-09T11:32:38.894842Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/var/lib/mysql/192.168.190.131.pid).

06-10

根据提示信息，错误信息为“log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'”和“The server quit without updating PID file (/var/lib/mysql/192.168.190.131.pid)”两个错误。第一个错误提示日志文件不存在，需要为用户“mysql”创建可写的日志目录。可以尝试使用命令“mkdir -p /var/log/mariadb && chown mysql:mysql /var/log/mariadb”创建日志目录并授权。第二个错误提示PID文件更新失败，可能是由于MySQL启动失败导致的。可以尝试使用命令“tail -f /var/log/mariadb/mariadb.log”查看日志文件最后的错误信息，或者尝试手动启动MySQL以获取更多的错误信息。