ran update, mysql stopped working ! HELP !

[fordfasterr]

(reposted from here: http://forums.linuxiso.org/viewtopic.php?t=27078) I figure this place might be able to help aswell...


Ok, I have been using knoppix for 2 years with a hard drive install.

I have the current version installed and everything seems to be working fine until I performed an update today (apt-get update && apt-get upgrade) ..

all of a sudden, mysqld is gone from my start-up list. ( so i re-added it and rebooted ), now it does not start back up even though I added it to all run levels including 3 and 5.

I try to run it manually as root and I get this error:

root@box_1:/etc/init.d# ./mysql start
Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I have the binaries here:

root@box_1:/usr/sbin# whereis mysql
mysql: /usr/bin/mysql /etc/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
root@box_1:/usr/sbin# whereis mysqld
mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz

[fordfasterr]

Ok, I fixed it..

here is what I found when I looked in the /var/log/syslog file..

Aug 22 09:54:42 box_1 mysqld[1725]: 050822  9:54:42 /usr/sbin/mysqld: unknown variable 'old_passwords=1'

so, I took a look at this file: /etc/mysql/my.cnf

and I found this line:

old_passwords = 1

so, I changed it to this to see what would happen:

#old_passwords = 1

then I ran mysql like this: /etc/init.d/mysql start

and voila. It loaded up fine, I tested some of my websites running on apache with php and it all works perfectly.......


SHEESH........