mysqld.sock missing

[Stephen Liu]

Hi folks,

ubuntu-6.06.1-LAMP-server-amd64

After running;
$ sudo apt-get -install mysql-server mysql-client.

mySQl did not start, complaining "mysqld.sock" missing.

On googling I found following postings;
http://ubuntuforums.org/showthread.php?t=111292
http://ubuntuforums.org/showthread.php?t=140036

$ cat /etc/mysql/my.cnf | grep .sock
# Remember to edit /etc/mysql/debian.cnf when changing the socket
location.
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
* end *

It was there.

$ sudo mysqld
Password:
061109 15:41:52  InnoDB: Started; log sequence number 0 43655
061109 15:41:52 [ERROR] Can't start server: Bind on TCP/IP port: Cannot
assign requested address
061109 15:41:52 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
061109 15:41:52 [ERROR] Aborting

061109 15:41:52  InnoDB: Starting shutdown...
061109 15:41:54  InnoDB: Shutdown completed; log sequence number 0
43655
061109 15:41:54 [Note] mysqld: Shutdown complete
* end *

$ sudo netstat -tap | grep mysql
Password:
No printout.


I can't figure a solution.  Please help.  TIA


B.R.
Stephen