MySQL:无法启动Server Debian Wheezy [英] Mysql: Can´t start Server debian wheezy

问题描述

每次我尝试启动mysql服务时，我都会遇到相同的错误

Everytime i try to start my mysql service i get the same error

错误消息:

150130 15:56:31 [错误]无法启动服务器:在TCP/IP端口上绑定:无法分配请求的地址150130 15:56:31 [错误]您是否已经在端口3305上运行了另一个mysqld服务器?150130 15:56:31 [ERROR]正在中止

150130 15:56:31 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 150130 15:56:31 [ERROR] Do you already have another mysqld server running on port: 3305 ? 150130 15:56:31 [ERROR] Aborting

我的错误日志为空

Conf文件摘要:

[客户]端口= 3305

[client] port = 3305

socket =/var/run/mysqld/mysqld.sock

socket = /var/run/mysqld/mysqld.sock

[mysqld]

user = mysql

user = mysql

pid文件=/var/run/mysqld/mysqld.pid

pid-file = /var/run/mysqld/mysqld.pid

socket =/var/run/mysqld/mysqld.sock

socket = /var/run/mysqld/mysqld.sock

端口= 3305

basedir =/usr

basedir = /usr

datadir =/var/lib/mysql

datadir = /var/lib/mysql

tmpdir =/tmp

tmpdir = /tmp

lc-messages-dir =/usr/share/mysql

lc-messages-dir = /usr/share/mysql

跳过外部锁定

• 对不起，我的英语不好

完成Conf文件

推荐答案

好像您的端口(3305)被另一个进程占用了.您可以:

Looks like your port(3305) is occupied by another process.. you can :

1)切换到其他端口

2)杀死/修改持有该端口的进程

2) kill/modify the process holding this port

(使用以下命令查找: lsof -i:3305 )

(look it up using: lsof -i :3305 )

此外，这可能是造成此问题的原因(如

in addition, this could be the cause of it (as one stated in this post) : Change bind-address to 127.0.0.1 instead of localhost

这篇关于MySQL:无法启动Server Debian Wheezy的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！