[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