莫名其妙的MySQL错误Can't create secure /var/tmp/mysql
来源:互联网 发布:python range迭代器 编辑:程序博客网 时间:2024/05/22 06:59
莫名其妙的不能启动MySQL,service mysql start总是报错:
# service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Can't create secure /var/tmp/mysql.rbOr3b failed
最后六个字符貌似一个随机串。
Baidu之,啥都木有,Google之,也是SUSE家的openSUSE论坛上有人求助,我的是高大的SLES。
看了半天,没人回答,反而几个人纠结在文法和表达形式上,鬼子就是闲得蛋疼。
只好自己琢磨/etc/init.d/mysql,找到出错的地方,瞄一眼就发现有问题。
然后命令行`id mysql`,竟然出来个这:
# id mysql
uid=60(mysql) gid=107(ntp) groups=107(ntp)
mysql啥时候和ntp勾搭在一起了,打开/etc/group一看果然,
#grep 107 /etc/group
/etc/group:mysql:!:107:
/etc/group:ntp:!:107:
再用看看MySQL和NTPrpm安装包里的script,
#rpm -q --scripts mysql ntp | grep group
/usr/sbin/groupadd -r mysql >/dev/null 2>/dev/null || :
/usr/sbin/groupadd -r ntp 2> /dev/null || :
非常标准普通的group添加方式,没有hardcode呀,估计跟RP有关了,不过应该是IT部门的RP
幸亏申请了Root权限,立马调整/etc/group,把mysql的gid换个新113,更新/etc/passwd里mysql的gid一并更新。
# service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL done
- 莫名其妙的MySQL错误Can't create secure /var/tmp/mysql
- mysql启动报can't create/write to file 'var/run/mysqld/mysqld.pid 错误解决办法
- mysql 出现 Can't create/write to file 的错误
- can't connect to local mysql server through socket '/tmp/mysql.sock'(2) in /var/...
- mysql连接错误: Can’t connect to local MySQL server through socket /tmp/mysql.sock
- 记录mysql错误:Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- mysql> desc tablename; ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI'
- 删/tmp下面的文件,好了吧,mysql连不了,ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var
- MYSQL中ERROR 1005 (HY000): Can't create table 错误
- MySQL: 1006 - Can't create database '***' (errno: 13) 错误
- mysql错误:Can’t create TCP/IP socket (10106)
- MySQL: 1006 - Can't create database '***' (errno: 13) 错误 解决方法
- mysql错误:Can’t create TCP/IP socket (10106) 解决方法
- mysql 常见错误:Can't create table... errno150原因分析
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'错误
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- iOS内存暴增问题追查与使用陷阱
- 山东理工大学ACM平台题答案关于C语言 1181 C语言实验——最小公倍数和最大公约数
- C#调用C++dll传参问题
- c++ builder 学习(1)
- mean shift算法的个人理解,请大家指教
- 莫名其妙的MySQL错误Can't create secure /var/tmp/mysql
- NYOJ 86 找球号(一)
- AspectJ
- 黑马程序员——java语言基础组成
- ElGamal的数据加密
- 未能加载文件或程序集另类解决办法
- 应用完全启动后, Spring执行自定义初始化
- 通用日志(Log)模块设计
- opencv 将BGR转为HSV