MySQL无法重启报错Warning: World-writable config file ‘/etc/my.cnf’ is ignored的解决方法
来源:互联网 发布:b站镇站之宝 知乎 编辑:程序博客网 时间:2024/05/17 01:39
最近在维护公司服务器的时候,在关闭数据库的命令发现mysql关不了了,提示错误为Warning: World-writable config file '/etc/my.cnf' is ignored,通过查找网上的资料终于解决了,现在将解决的方法分享给大家,同样遇到这个问题的朋友们可以参考借鉴。
问题分析
在关闭数据库的命令发现mysql关不了,提示Warning: World-writable config file '/etc/my.cnf' is ignored
,大概意思是权限全局可写,任何一个用户都可以写。mysql担心这种文件被其他用户恶意修改,所以忽略掉这个配置文件。这样mysql无法关闭。
下面看下整个过程
重启MySQL
可以看到mysql停止不了
查看my.cnf的权限
权限777,任何一个用户都可以改my.cnf
,存在很大的安全隐患.
修复MySQL问题
my.cnf设置为用户可读写,其他用户不可写.
关闭MySQL
MySQL关闭成功. 问题很简单
阅读全文
0 0
- MySQL无法重启报错Warning: World-writable config file ‘/etc/my.cnf’ is ignored的解决方法
- MySQL无法重启报错Warning: World-writable config file ‘/etc/my.cnf’ is ignored的解决方法
- MySQL无法重启问题解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- MySQL无法重启问题解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- MySQL无法重启问题解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- Warning: World-writable config file '/etc/my.cnf' is ignored
- Warning: World-writable config file '/etc/my.cnf' is ignored
- Warning: World-writable config file '/etc/my.cnf' is ignored
- Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
- Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
- linux MYSQL Warning: World-writable config file './my.cnf' is ignored解决方法
- warning: World-writable config file /opt/lampp/etc/my.cnf is ignored
- 解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- 解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- Warning: World-writable config file '/data0/mysql/3306/my.cnf' is ignored
- 装xampp遇到World-writable config file‘/opt/lampp/etc/my.cnf’is ignored错误
- Docker mysql [Warning] World-writable config file '.cnf' is is ignored
- mysql启动warning: World-writable config file
- 解决App Store 上架 IOS 程序必须支持IPV6
- javascript 基础
- Android事件分发源码分析
- 设计模式
- 待补题目
- MySQL无法重启报错Warning: World-writable config file ‘/etc/my.cnf’ is ignored的解决方法
- 设计模式六大原则(1):单一职责原则
- 现汉语语法和体系学习笔记
- avcodec_open(pCodecCtx, pCodec
- Eclipse转Android studio运行时等问题 编码乱码 閿欒: 缂栫爜UTF-8鐨勪笉鍙槧灏勫瓧绗?
- java语言概述
- 线性表(顺序表和链式表)
- php获取客户端IP和php获取服务器端IP
- 对称矩阵压缩和三种解压缩方式