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
problem for me seems to lie in mysql_upgrade, ie.
# less /var/lib/ mysql/crystaltr ee.err
090114 15:19:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql mysqld/ mysqld. pid ended
/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/
but cant successfully run upgrade since cant start mysql server
# mysql_upgrade
Looking for 'mysql' as: mysql mysqld/ mysqld. sock' (2) when trying to connect
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/
FATAL ERROR: Upgrade failed