Friday, July 8, 2011

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