[SOLVED] After Debian upgrade, MySQL will not start

Spetnik · 10-02-2011, 08:31 AM

After upgrading a Debian test machine from Lenny to Squeeze, MySQL will no longer start.

When running /etc/init.d/mysql start, it responds that starting MySQL failed.

The following appears in the syslog:

Code:

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

Any help would be greatly appreciated - thanks!

update:
I just tried running "/usr/sbin/mysqld" from the command line, and received the following:

Code:

111002  8:43:11 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
111002  8:43:12 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111002  8:43:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111002  8:43:12  InnoDB: Started; log sequence number 0 10980411
111002  8:43:12 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
111002  8:43:12 [ERROR] Aborting

111002  8:43:12  InnoDB: Starting shutdown...
111002  8:43:18  InnoDB: Shutdown completed; log sequence number 0 10980411
111002  8:43:18 [Note] /usr/sbin/mysqld: Shutdown complete

jonkiribati · 10-02-2011, 08:56 AM

111002 8:43:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

did you try to run mysql_upgrade command ?

Spetnik · 10-02-2011, 08:58 AM

I've been looking for it, but cannot find it. Where is mysql_upgrade located?

Spetnik · 10-03-2011, 07:40 AM

UPDATE:
I tried replacing my.cnf with the original one and now I can start it with /usr/sbin/mysqld (still getting the "mysql_upgrade" messages, but I cannot find "mysql_upgrade" anywhere on the machine). However, /etc/init.d/mysql start still fails with the same messages in /var/logs/syslog.

Spetnik · 10-03-2011, 01:01 PM

Well, for some strange reason, it seems that mysql-server was not installed (according to apt-get). So I ran apt-get install mysql-server and it works! Weird - I wonder what happened during the Debian upgrade.

sut · 04-25-2012, 06:42 AM

Thank You - Same Problem here - solved...