无法启动服务器：绑定TCP / IP端口：无法分配请求的地址

我昨天重新启动了我的服务器，不幸的是现在无法启动mysql。

错误日志如下所示：

root@site-digger:/var/log/mysql# cat error.log 130216 16:11:32 [Note] Plugin 'FEDERATED' is disabled. 130216 16:11:32 InnoDB: Initializing buffer pool, size = 8.0M 130216 16:11:32 InnoDB: Completed initialization of buffer pool 130216 16:11:33 InnoDB: Started; log sequence number 0 1382359817 130216 16:11:33 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 130216 16:11:33 [ERROR] Do you already have another mysqld server running on port: 3306 ? 130216 16:11:33 [ERROR] Aborting 130216 16:11:33 InnoDB: Starting shutdown... 130216 16:11:38 InnoDB: Shutdown completed; log sequence number 0 1382359817 130216 16:11:38 [Note] /usr/sbin/mysqld: Shutdown complete ... 

我查了一下，没有find任何程序正在使用3306，请看下面。

 root@site-digger:/var/log/mysql# sudo netstat Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 site-digger.com:59367 li566-52.members.li:ssh ESTABLISHED tcp 0 0 site-digger.com:ssh 61.150.56.248:65255 ESTABLISHED tcp 0 216 site-digger.com:ssh 61.150.56.248:61553 ESTABLISHED tcp 0 0 site-digger.com:www 1.82.9.18:55526 TIME_WAIT Active UNIX domain sockets (w/o servers) Proto RefCnt Flags Type State I-Node Path unix 2 [ ] DGRAM 600880492 unix 3 [ ] STREAM CONNECTED 600845962 unix 3 [ ] STREAM CONNECTED 600845961 unix 3 [ ] STREAM CONNECTED 600596531 unix 3 [ ] STREAM CONNECTED 600596530 

我试过sudo mysql启动。 但仍然没有工作。 操作系统：Ubuntu 11.10

• MySQL在Ubuntu 11.04上每30分钟重新启动一次
• MariaDB无法在更新后启动：无法创buildtesting文件/home/mysql/beta.lower-test
• 在linux中设置Mysql ++
• Ubuntu – 12.04 – MySql不会通过使用服务启动mysql
• 安装期间出现phpmyadmin错误“指定了”端口“的空值。

netstat -a -t的结果如下：

 root@site-digger:/var/log/mysql# netstat -a -t Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 *:www *:* LISTEN tcp 0 0 *:ssh *:* LISTEN tcp 0 0 *:https *:* LISTEN tcp 0 20824 site-digger.com:59367 li566-52.members.li:ssh ESTABLISHED tcp 0 0 site-digger.com:ssh 61.150.56.248:65255 ESTABLISHED tcp 0 52 site-digger.com:ssh 61.150.56.248:61553 ESTABLISHED tcp 0 0 site-digger.com:www crawl-66-249-73-2:45760 TIME_WAIT tcp 0 0 site-digger.com:www 218.30.103.146:49094 TIME_WAIT tcp6 0 0 [::]:ssh [::]:* LISTEN