can't open the mysql.plugin mysql_upgrade to create it 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




FOLLOW US :-    
   





6 comments :

  1. Thank you. This saved my day :)

    ReplyDelete
  2. Ohhh FUN !!!
    After 1 hr....your solution
    Thx

    ReplyDelete
  3. Thank you so much. This is exactly what my problem was!

    ReplyDelete
  4. Thanks for posting this. Had the exact same problem when upgrading to PHP 5.3.8 which forced an upgrade to MySQL 5.5 and boom, my clients entire server is down because it relies on MySQL.

    I was scrambling for the fix, finding the answer here really saved me a lot of time trying to muck around with it. Thanks again.

    ReplyDelete
  5. remove config entries from where?

    ReplyDelete
    Replies
    1. edit /etc/my.cnf
      and remove the above mentioned parameters.

      Delete