Re: MySql will not restart

On Sun, Oct 14, 2007 at 05:43:50 -0700, harland christofferson wrote:
running 2.4.27-2-k7

For years, MySql was running fine.

This a.m., webpages were not being served.

I thought that it was MySql.

I tried this:

#/etc/init.d/mysql restart

I received this:

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 followed instructions:

#grep mysql /var/log/syslog

Yields:

/etc/init.d/mysql[14242]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/init.d/mysql[14242]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
/etc/init.d/mysql[14242]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
/etc/init.d/mysql[14242]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

There is no /var/run/mysqld/mysqld.sock file

My /etc/mysql/debian.cnf is:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = XXXXXXXXXXXXXXXX
socket = /var/run/mysqld/mysqld.sock

I only have a general suggestion: Have a look at /var/log/daemon.log, it
sometimes contains more information about what goes wrong with daemon
processes.

--
Regards, | http://users.icfo.es/Florian.Kulzer
Florian |


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx

Relevant Pages

  • Re: lost mysql root password
    ... On Friday 03 March 2006 02:20 pm, Matt Price wrote: ... Now I'm back to configuring some programs that use mysql, ... | hash 1 ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: [PHP] php cli and mysql
    ... James Tu wrote: ... Why is the CLI looking for it at /var/myslq/mysql.sock? ... Do I change the mysql settings so that mysql.sock is at ... To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)
  • Re: Getting started with Postgres or MySQL
    ... statement has begun executing. ... MySQL with the MyISAM data store is *exactly* what you describe. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: MySQL goes away?
    ... NOTICE: reconnecting in response to: err=2006, S1000, ... take a look at your mysql log files, and then restart the daemon - ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • RE: File not found error
    ... after downloading, issuing a mv or rm command does not ... error: File not found by glob: MySql* ... Check out the new Yahoo! ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)