[Bug 316974] Re: Mysql dead after update

[Dinxter]

problem for me seems to lie in mysql_upgrade, ie.

# less /var/lib/mysql/crystaltree.err

090114 15:19:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090114 15:19:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090114 15:19:39  InnoDB: Started; log sequence number 0 46409
090114 15:19:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090114 15:19:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

but cant successfully run upgrade since cant start mysql server

# mysql_upgrade

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

-- 
Mysql dead after update
https://bugs.launchpad.net/bugs/316974
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.