mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
来源:互联网 发布:编程语言发展趋势 编辑:程序博客网 时间:2024/06/06 16:34
在Linux<CentOS>服务器上安装Mysql,由于Centos自身的yum源中用Mysql的分支Mariadb代替了MySQL,所以不得不选择rpm或tar.gz包的方式安装,
但是为了以后在其他LInux如Ubuntu中也能熟练安装MySQL,所以推荐使用tar.gz,安装教程—http://blog.csdn.net/qq_32331073/article/details/76252559
运行命令:service mysqld start
出现如下错误:
Starting MySQL.Logging to '/usr/local/mysql/data/iZ2ze8hspx8qsmxx7b1i9sZ.err'.170728 09:47:55 mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists. ERROR! The server quit without updating PID file (/usr/local/mysql/data/iZ2ze8hspx8qsmxx7b1i9sZ.pid).随即执行命令:cat /usr/local/mysql/data/iZ2ze8hspx8qsmxx7b1i9sZ.err查看错误原因
error内容如下:
[ERROR] Can't start server : Bind on unix socket: Permission denied[ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
结合先前写入配置/etc/my.cnf:
由上不难理解——
第一:
mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
“var/lib/mysql”目录不存在,首要先创建:
mkdir /var/lib/mysql
第二:
Mysql客户端和服务器端是通过初始化mysql.sock 文件来进行通信,所以服务器在启动时需要写入该文件,因此该文件所存放的目录必须双方都
具有访问权限。而异常日志中表示:
[ERROR] Can't start server : Bind on unix socket: Permission denied
所以,MySQL服务不具备目录 /var/lib/mysql 的写入权限,无法生成mysql.sock文件,自然服务启动时无法找到该文件。
给目录 /var/lib/mysql 付予写入权限或者最大权限—chmod 777 /var/lib/mysql
最终:
阅读全文
1 0
- mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
- mysqld_safe --skip-grant&提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- 解决mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- however file don't exists. Create writable for user 'mysql'.
- Socket file /var/lib/mysql/mysql.sock exists. Is another MySQL daemon already running with the same
- log-error set to '/usr/local/mysql/log/mysqld.log', however file don't exists
- mysql启动Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ mysql.sock
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- eoiioe Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’解决方法
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 问题解决
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- JavaScript: 最简单的事件代理(JS Event Proxy)原理代码
- Get请求中文乱码问题有效解决方法
- 客户端如何访问greenplum
- linux驱动开发--内核链表
- Html5之数据持久化学习
- mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
- 简单的eclipse应用jna入门和实例
- 画线
- mysql修改用户密码
- RecyclerView Item 布局宽高无效问题探究
- HDU 1176 免费馅饼(DP)
- 13 在ZStack里设置pan ID和信号输出功率
- 一文读懂机器学习,大数据/自然语言处理/算法全有了
- QEMU(Centos7)环境搭建流程