Friday, July 2

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

 Mysqld error while starting

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

Fix:
After removing the following config entries I was able to start mysqld
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 :-        
                Google+         Follow Me on Pinterest

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