ubuntu mysql 不正常停止后启动不起来

站内留言 发布于 2015/07/20 16:35
阅读 2K+
收藏 0

解读下一代网络:算力网络正从理想照进现实!>>>

150720 16:33:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150720 16:33:18 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
150720 16:33:18 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 28957 ...
150720 16:33:18 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150720 16:33:18 [Note] Plugin 'FEDERATED' is disabled.
150720 16:33:18 InnoDB: The InnoDB memory heap is disabled
150720 16:33:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150720 16:33:18 InnoDB: Compressed tables use zlib 1.2.8
150720 16:33:18 InnoDB: Using Linux native AIO
150720 16:33:18 InnoDB: Initializing buffer pool, size = 128.0M
150720 16:33:18 InnoDB: Completed initialization of buffer pool
150720 16:33:18 InnoDB: highest supported file format is Barracuda.
150720 16:33:18  InnoDB: Waiting for the background threads to start
150720 16:33:19 InnoDB: 5.5.43 started; log sequence number 1595675
150720 16:33:19 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150720 16:33:19 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
150720 16:33:19 [Note] Server socket created on IP: '127.0.0.1'.
150720 16:33:19 [ERROR] Can't start server : Bind on unix socket: Permission denied
150720 16:33:19 [ERROR] Do you already have another mysqld server running on socket: /var/mysqld/mysqld.sock ?
150720 16:33:19 [ERROR] Aborting

150720 16:33:19  InnoDB: Starting shutdown...
150720 16:33:19  InnoDB: Shutdown completed; log sequence number 1595675
150720 16:33:19 [Note] /usr/sbin/mysqld: Shutdown complete

150720 16:33:19 mysqld_safe mysqld from pid file /var/mysqld/mysqld.pid ended

加载中
0
Feng_Yu
Feng_Yu

日志不都有了么?检查下mysql的进程是否存在,如果不存的话删掉那个sock文件重启就行了。

学会分析日志,不要一遇到问题就问问问

Feng_Yu
Feng_Yu
回复 @站内留言 : 怀疑你自己乱抄了一个mysql的配置覆盖过去了。ubuntu下的mysql的sock文件应该在/var/run/mysqld/mysqld.sock,/var/mysqld这个目录本来就不存在
站内留言
站内留言
进程不存在,文件也不存在……
0
junan
junan

创建此目录,并chown,问题解决。


# mkdir /var/run/mysqld

# chown mysql:mysql /var/run/mysqld

0
blackjune
blackjune
150720 16:33:19 [ERROR] Can't start server : Bind on unix socket: Permission denied
150720 16:33:19 [ERROR] Do you already have another mysqld server running on socket: /var/mysqld/mysqld.sock ?
150720 16:33:19 [ERROR] Aborting

要看日志
返回顶部
顶部