Can’t open the mysql.plugin table. Please run mysql_upgrade to create it : MYSql Error: Solved


Mysqld error: can’t open the mysql.plugin mysql_upgrade to create it – while starting

Error: 

can’t open the mysql.plugin mysql_upgrade to create it

After upgrading my fedora11 to fedora 12, mysqld server stopped working and I gets the following error at start up

100702 14:52:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

100702 14:53:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100702 14:53:28 [Note] Plugin ‘ndbcluster’ is disabled.
/usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist
100702 14:53:28 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
100702 14:53:29  InnoDB: Started; log sequence number 0 44233
100702 14:53:29 [ERROR] /usr/libexec/mysqld: unknown option ‘–skip-bdb’
100702 14:53:29 [ERROR] Aborting


Solution:

After removing the following obsolete config entries, mysqld started working

and run mysql_upgrade.

#skip-innodb
#skip-bdb
#skip-federated

So I commented out:
#skip-locking
#skip-innodb
#skip-bdb

Now i started MySQL

#service mysqld start
Starting MySQL:                                            [  OK  ]

Then I run mysql_upgrade

#mysql_upgrade  -uroot -p
#service mysqld restart
And now everything is working fine