MySQL install problem

bill purvis bil at beeb.net
Sat Oct 27 16:29:42 UTC 2007


I've been trying to figure out what was going on when I tried to
install mysql-server-5.0 on my new system (7.01 Feisty?).

I had run out of space on /var during the initial install, got around
that by moving /var onto another partition. Tried running 
/etc/init.d/mysql start
but it just says [fail].
After much searching found the output was in /var/log/daemon.log.
Various messages suggested that there was a duplicate key being
inserted into one of the initial database files, so I did a
apt-get --purge remove mysql-server-5.0
to get rid of all the config files, including the database files.
Reinstalled but still got an error. However, this time it comes up
with:

Oct 27 17:17:48 felix mysqld[11012]: 071027 17:17:48  InnoDB: Started; log 
sequence number 0 0
Oct 27 17:17:48 felix mysqld[11012]: 071027 17:17:48 [ERROR] Can't start 
server:
 Bind on TCP/IP port: Cannot assign requested address
Oct 27 17:17:48 felix mysqld[11012]: 071027 17:17:48 [ERROR] Do you already 
have another mysqld server running on port: 3306 ?
Oct 27 17:17:48 felix mysqld[11012]: 071027 17:17:48 [ERROR] Aborting

followed by other stuff that fails, presumably as a consequence.
Ran netstat -ltp to see what might be using 3306, but nothing of relevance:

root at felix:/etc/init.d# netstat -ltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address    Foreign Address  State PID/Program name   
tcp        0      0 localhost:2208   *:*              LISTEN     4738/hpiod          
tcp        0      0 *:www            *:*              LISTEN     6786/apache2        
tcp        0      0 localhost:2207   *:*              LISTEN     4743/python         

Any suggestions?

Bill
-- 
+---------------------------------------+
| Bill Purvis, Amateur Mathematician    |
|  email: bil at beeb.net                  |
|  http://bil.members.beeb.net          |
+---------------------------------------+




More information about the ubuntu-users mailing list