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
mysqld died here. it ain't running no more.
reason: old_passwords=1 is an invalid configuration item
check your config files like ~/.my.cnf
this is evidence that you had an older version of mysql on
your system and then replaced it with a newer version
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]:
the socket does not exist because mysqld is not running
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/mysqld.sock' does not exist.
Tux:/var/run/mysqld# ls -la
total 8
drwxr-xr-x 2 mysql root 4096 Aug 4 22:10 .
ditto
Since your system seems a bit mashed w.r.t. mysqld, I suggest you
clean up (remove) all old mysql stuff (locate is helpful!) and reinstall
it. You'll be far better off that way with a fresh install.
cheers
rickw
--
_________________________________
Rick Welykochy || Praxis Services
Why do people who know HTML write plain text emails and those who
don't attempt to write HTML emails?
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
