MySQL无法重启问题解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
来源:互联网 发布:08奥运会韦德数据 编辑:程序博客网 时间:2024/05/16 17:44
今天帮朋友维护服务器,在关闭数据库的命令发现mysql关不了,提示Warning: World-writable config file '/etc/my.cnf' is ignored ,大概意思是权限全局可写,任何一个用户都可以写。mysql担心这种文件被其他用户恶意修改,所以忽略掉这个配置文件。这样mysql无法关闭。
下面看下整个过程
重启MySQL
可以看到mysql停止不了
查看my.cnf的权限
权限777,任何一个用户都可以改my.cnf,存在很大的安全隐患.
修复MySQL问题
my.cnf设置为用户可读写,其他用户不可写.
关闭MySQL
1
2
[root@ttlsa~]# service mysqld stop
ShuttingdownMySQL..[ OK ]
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
- 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
- linux MYSQL Warning: World-writable config file './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
- 【Java学习】——SSH总结
- Atitit 我们的devops战略与规划 规范 推荐标准
- 第三方登录
- CSS中行内元素和块级元素区别
- 比酒量
- MySQL无法重启问题解决Warning: World-writable config file ‘/etc/my.cnf’ is ignored
- VGG:VERY DEEP CONVOLUTIONAL NETWORKS FOR LARGE-SCALE IMAGE RECOGNITION译文
- 2016-2017 Tue&Thus Training
- CentOS下安装JDK的三种方法
- CSAPP-深入理解计算机系统-目录+书评
- Linux C 信号处理机制
- 浅谈增量部署的svn和全量部署的git
- BeautifulSoup的使用
- HTML5--web存储