Mysqld error: can’t open the mysql.plugin mysql_upgrade to create it – while starting
Error:
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:
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
Thank you. This saved my day 🙂
Ohhh FUN !!!
After 1 hr….your solution
Thx
Thank you so much. This is exactly what my problem was!
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.
remove config entries from where?
edit /etc/my.cnf
and remove the above mentioned parameters.