mysql启动时报 Bind on unix socket Address already in use的问题处理
来源:互联网 发布:android 电子书源码 编辑:程序博客网 时间:2024/06/05 09:08
一.问题描述:
版本:mariadb 10.0.19
启动MySQL:
/apps/svr/mariadb10/bin/mysqld_safe --defaults-file=/apps/dbdat/mariadb10_data3306/my.cnf --socket=/tmp/mysql.sock &
无法启动,mysql进程退出。
二.问题分析:
检查error log,如下:
160826 15:33:33 [Note] Server socket created on IP: '0.0.0.0'.
160826 15:33:33 [ERROR] Can't start server : Bind on unix socket: Address already in use
160826 15:33:33 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql3306.sock ?
160826 15:33:33 [ERROR] Aborting
160826 15:33:33 [Note] InnoDB: FTS optimize thread exiting.
160826 15:33:33 [Note] InnoDB: Starting shutdown...
160826 15:33:36 [Note] InnoDB: Shutdown completed; log sequence number 452295626292
160826 15:33:36 [Note] /apps/svr/mariadb10/bin/mysqld: Shutdown complete
160826 15:33:36 mysqld_safe mysqld from pid file /apps/dbdat/mariadb10_data3306/mysql.pid ended
上面提示unix socket /tmp/mysql3306.sock 被占用,用ps -ef|grep mysql检查没有其它mysql进程.用netstat -an|grep 3306检查端口也不存在。
对比分析,正常关闭mysql时,/tmp/mysql3306.sock文件是不存在的,而现在mysql已关闭后,还存在/tmp/mysql3306.sock文件。
猜测是由于上次mysql未正常关闭或关闭异常引起。
三.问题解决:
在root用户下,删除/tmp/mysql.sock文件,再重启mysql。
- mysql启动时报 Bind on unix socket Address already in use的问题处理
- mysql启动时报 Bind on unix socket Address already in use的问题处理
- Tomcat启动时报java.net.BindException:Address already in use:JVM Bind:8443错误的解决方法
- MySQL "Bind on TCP/IP port: Address already in use"
- MySQL启动报错“Bind on TCP/IP port: Address already in use”
- redis启动时遇到的问题 Creating Server TCP listening socket *:6379: bind: Address already in use
- 安装JBoss服务器与启动时遇到:Address already in use:bind /127.0.0.1:9990的问题的处理办法!
- Linux下Socket编程的端口问题( Bind(): Address already in use )
- Linux下Socket编程的端口问题( Bind(): Address already in use )
- Linux下Socket编程的端口问题( Bind error: Address already in use )
- Linux下Socket编程的端口问题( Bind(): Address already in use )
- Linux下Socket编程的端口问题( Bind(): Address already in use )
- Linux下Socket编程的端口问题( Bind(): Address already in use )
- Linux下Socket编程的端口问题( Bind error: Address already in use )
- Linux下Socket编程的端口问题( Bind error: Address already in use )
- Linux下Socket编程的端口问题( Bind error: Address already in use )
- Linux下Socket编程的端口问题( Bind error: Address already in use )
- Python: socket,address already in use处理
- Redis相关
- leetcode_middle_22_12. Integer to Roman
- 使用cryptography进行RSA加密
- MyBatis中多对多关系的映射和查询
- 网页访问IE8以下CLOSE浏览器
- mysql启动时报 Bind on unix socket Address already in use的问题处理
- tips使用
- 外部看门狗驱动模块支持-max706s
- Android硬件抽象层(HAL)深入剖析(二)
- linux终端后台运行程序
- |poj 2406|KMP|Power Strings
- google chrome 插件开发
- Hadoop 2.6.3动态增加/删除DataNode节点
- 关于Android触摸事件的一些理解