Can't start mysql

dtr657 · Post by **dtr657** » 10 Nov 2008, 07:07

Hi, I can not start mysql. Whenever I try to start it i get the following:

bubba:/var/log# /etc/init.d/mysql status
MySQL is stopped..
bubba:/var/log# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
bubba:/var/log# tail -27 syslog
Nov 10 13:53:55 bubba mysqld_safe[14142]: started
Nov 10 13:53:56 bubba mysqld[14145]: 081110 13:53:56  InnoDB: Started; log sequence number 0 45548
Nov 10 13:53:56 bubba mysqld[14145]: 081110 13:53:56 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov 10 13:53:56 bubba mysqld[14145]: 081110 13:53:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov 10 13:53:56 bubba mysqld[14145]: 081110 13:53:56 [ERROR] Aborting
Nov 10 13:53:56 bubba mysqld[14145]:
Nov 10 13:53:56 bubba mysqld[14145]: 081110 13:53:56  InnoDB: Starting shutdown...
Nov 10 13:53:58 bubba mysqld[14145]: 081110 13:53:58  InnoDB: Shutdown completed; log sequence number 0 45548
Nov 10 13:53:58 bubba mysqld[14145]: 081110 13:53:58 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 10 13:53:58 bubba mysqld[14145]:
Nov 10 13:53:58 bubba mysqld_safe[14164]: ended
Nov 10 13:54:03 bubba mysqld_safe[14237]: started
Nov 10 13:54:04 bubba mysqld[14240]: 081110 13:54:04  InnoDB: Started; log sequence number 0 45548
Nov 10 13:54:04 bubba mysqld[14240]: 081110 13:54:04 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov 10 13:54:04 bubba mysqld[14240]: 081110 13:54:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov 10 13:54:04 bubba mysqld[14240]: 081110 13:54:04 [ERROR] Aborting
Nov 10 13:54:04 bubba mysqld[14240]:
Nov 10 13:54:04 bubba mysqld[14240]: 081110 13:54:04  InnoDB: Starting shutdown...
Nov 10 13:54:06 bubba mysqld[14240]: 081110 13:54:06  InnoDB: Shutdown completed; log sequence number 0 45548
Nov 10 13:54:06 bubba mysqld[14240]: 081110 13:54:06 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 10 13:54:06 bubba mysqld[14240]:
Nov 10 13:54:06 bubba mysqld_safe[14268]: ended
Nov 10 13:54:19 bubba /etc/init.d/mysql[14385]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 10 13:54:19 bubba /etc/init.d/mysql[14385]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 10 13:54:19 bubba /etc/init.d/mysql[14385]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 10 13:54:19 bubba /etc/init.d/mysql[14385]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 10 13:54:19 bubba /etc/init.d/mysql[14385]:

And there is nothing in mysql.err either. I have not changed the default configuration in any way. I have nothing listening on port 3306. Does anyone know what could be wrong?