mysql - Can't start server: Bind on TCP/IP port: Cannot assign requested address -

mysql - Can't start server: Bind on TCP/IP port: Cannot assign requested address -

i rebooted server yesterday, unfortunately mysql cannot started now.

the error log following:

root@site-digger:/var/log/mysql# cat error.log 130216 16:11:32 [note] plugin 'federated' 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] have 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 finish ...

i checked , didn't find programme using 3306, please see following.

root@site-digger:/var/log/mysql# sudo netstat active net 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

i tried sudo mysql start. still not working. os: ubuntu 11.10

the results netstat -a -t following:

root@site-digger:/var/log/mysql# netstat -a -t active net connections (servers , established) proto recv-q send-q local address foreign address state tcp 0 0 *:www *:* hear tcp 0 0 *:ssh *:* hear tcp 0 0 *:https *:* hear 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 [::]:* hear

port 33 06. not 60. netstat shows active connections, not idle ones simply listening. need netstat -a -t (to show tcp ports).

mysql ubuntu