[wellylug] MySQL teething problems

[Cliff Pratt]

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 ..
> 
> 
Hmm, I prefer the other database, but I do have mysql 
running. So I stopped it and started it and got the same 
error! Maybe it's a package error.

Here's what I have (plse excuse the wrapping....
debian:/etc/mysql# dpkg -l | grep mysql
ii  libdbd-mysql-perl                2.9007-1 
     A Perl5 database interface to the MySQL data
ii  libmysqlclient10                 3.23.56-3 
     LGPL-licensed client library for MySQL datab
ii  libmysqlclient12                 4.0.24-10 
     mysql database client library
ii  libmysqlclient14                 4.1.13a-1 
     mysql database client library
ii  mysql-client                     4.0.24-10 
     mysql database client binaries
ii  mysql-common                     5.0.7beta-1 
     mysql database common files (e.g. /etc/mysql
ii  mysql-doc                        4.0.24-1 
     mysql database documentation
ii  mysql-server                     4.0.24-10 
     mysql database server binaries
ii  php4-mysql                       4.3.10-15 
     MySQL module for php4

I'm not sure that 4.0 goes with the 4.1 client, but I don't 
think that's the problem.

If I find anything I'll let you know.

Cheers,

Cliff