{"id":1832,"date":"2012-03-24T08:42:24","date_gmt":"2012-03-24T12:42:24","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=1832"},"modified":"2013-03-20T08:38:23","modified_gmt":"2013-03-20T12:38:23","slug":"mysql-failed-after-upgrade-table-mysql-plugin-doesnt-exist","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/mysql-failed-after-upgrade-table-mysql-plugin-doesnt-exist","title":{"rendered":"Mysql failed after upgrade: Table ‘mysql.plugin’ doesn’t exist"},"content":{"rendered":"

After performing a mysql upgrade, you may run into a problem where Mysql won’t start successfully and will result in a “Table ‘mysql.plugin’ doesn’t exist” error message. The mysql error logs will state something like follows:<\/p>\n

\n
\/usr\/libexec\/mysqld: Table 'mysql.plugin' doesn't exist\r\n110620\u00a0 01:01:01 [ERROR] Can't open the mysql.plugin table.\r\nPlease run mysql_upgrade to create it.<\/pre>\n<\/blockquote>\n
The solution is to run mysql_upgrade<\/strong> to create the mysql.plugin table but the problem is you can execute the command only when Mysql is online. Tricky situation, isn’t it?<\/p>\n
This mostly likely happens when mysql is still using the old my.cnf file after the upgrade.<\/strong> The my.cnf of the new Mysql version is saved as \/etc\/my.cnf.rpmnew and this is the file you should be using<\/p>\n
\n
# cp \/etc\/my.cnf \/etc\/my.cnf.old<\/span>\r\n# cp \/etc\/my.cnf.rpmnew \/etc\/my.cnf<\/span>\r\n# \/etc\/init.d\/mysqld start<\/span><\/pre>\n<\/blockquote>\n
Once Mysql is started, you can now execute mysql_upgrade:<\/p>\n
\n
# mysql_upgrade -uroot -p <mysqlpass><\/span><\/pre>\n<\/blockquote>\n
This will create the ‘mysql.plugin’ table and will make sure the mysql database is uptodate as per the newer version.<\/p>\n","protected":false},"excerpt":{"rendered":"
After performing a mysql upgrade, you may run into a problem where Mysql won’t start successfully and will result in a “Table ‘mysql.plugin’ doesn’t exist” error message. The mysql error logs will state something like follows:<\/p>\n
\/usr\/libexec\/mysqld: Table ‘mysql.plugin’ doesn’t exist
\n110620\u00a0 01:01:01 [ERROR] Can’t open the mysql.plugin table.
\nPlease run mysql_upgrade to create it.<\/p>\n
The solution is to run mysql_upgrade to create the mysql.plugin table but the problem is you can execute the command only when Mysql is online. Tricky situation, isn’t it?
\nThis mostly likely happens when mysql is still using […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[1373,1375,1372,1374],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/1832"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=1832"}],"version-history":[{"count":5,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/1832\/revisions"}],"predecessor-version":[{"id":1835,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/1832\/revisions\/1835"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=1832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=1832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=1832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}