[wellylug] MySQL teething problems

Cliff Pratt enkidu at cliffp.com
Sun Aug 21 22:04:10 NZST 2005


Adam Bogacki wrote:
> Hi, I'm having some trouble getting mysql going.
> I've had it on my system for a while, had a bash at it once using a
> long-forgotten password, and never did
> get it working properly. Now I'm getting the error message below.
> 
> 
>>Aug 21 14:53:19 tux mysqld_safe[3459]: started
>>Aug 21 14:53:19 tux mysqld[3463]: 050821 14:53:19 /usr/sbin/mysqld:
>>unknown variable 'old_passwords=1'
>>Aug 21 14:53:19 tux mysqld[3463]:
>>Aug 21 14:53:19 tux mysqld_safe[3465]: ended
>>Aug 21 14:53:25 tux /etc/init.d/mysql[3528]: 0 processes alive and
>>'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
>>resulted in
>>Aug 21 14:53:25 tux /etc/init.d/mysql[3528]: ^G/usr/bin/mysqladmin:
>>connect to server at 'localhost' failed
>>Aug 21 14:53:25 tux /etc/init.d/mysql[3528]: error: 'Can't connect to
>>local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
>>Aug 21 14:53:25 tux /etc/init.d/mysql[3528]: Check that mysqld is
>>running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
>>Aug 21 14:53:25 tux /etc/init.d/mysql[3528]:
> 
> 
> Trying to run mysql does not work,
> 
> 
>>Tux:~# mysql
>>ERROR 2002: Can't connect to local MySQL server through socket
>>'/var/run/mysqld/mysqld.sock' (2)
> 
> 
> 
> and '/var/run/mysqld.sock' does not exist.
> 
> 
>>Tux:/var/run/mysqld# ls -la
>>total 8
>>drwxr-xr-x   2 mysql root 4096 Aug  4 22:10 .
>>drwxr-xr-x  27 root  root 4096 Aug 21 13:30 ..
> 
It's a bug, see here:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=321578

Comment out the old_passwords line and it starts OK.

Cheers,

Cliff




More information about the wellylug mailing list