{"id":710,"date":"2012-09-11T03:59:18","date_gmt":"2012-09-11T03:59:18","guid":{"rendered":"http:\/\/www.omniweb.com\/wordpress\/?p=710"},"modified":"2012-09-11T03:59:18","modified_gmt":"2012-09-11T03:59:18","slug":"trouble-starting-mysql-on-centos-cant-find-file-mysqlplugin-frm-errno-13","status":"publish","type":"post","link":"https:\/\/www.omniweb.com\/wordpress\/?p=710","title":{"rendered":"Trouble starting MySQL on CentOS: Can&#8217;t find file: &#8216;.\/mysql\/plugin.frm&#8217; (errno: 13)"},"content":{"rendered":"<p>While trying to set up a new MySQL slave on Centos 5, i copied over the \/var\/lib\/mysql directory and made necessary updates but Mysql would not start, in \/var\/log\/mysql.log there was this <\/p>\n<p><code>120910 13:40:00 mysqld_safe mysqld from pid file \/var\/lib\/mysql\/omni1.omniweb.com.pid ended<br \/>\n120910 13:42:08 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<br \/>\n120910 13:42:08 [ERROR] \/usr\/sbin\/mysqld: Can't find file: '.\/mysql\/plugin.frm' (errno: 13)<br \/>\n120910 13:42:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.<br \/>\n120910 13:42:08 [ERROR] Falcon: can't open file \"\/var\/lib\/mysql\/falcon_master.fts\": Permission denied (13)<br \/>\n120910 13:42:08 [ERROR] Plugin 'Falcon' init function returned error.<br \/>\n120910 13:42:08 [ERROR] Plugin 'Falcon' registration as a STORAGE ENGINE failed.<br \/>\n120910 13:42:08  InnoDB: Operating system error number 13 in a file operation.<br \/>\nInnoDB: The error means mysqld does not have the access rights to<br \/>\nInnoDB: the directory.<br \/>\nInnoDB: File name .\/ibdata1<br \/>\nInnoDB: File operation call: 'open'.<br \/>\nInnoDB: Cannot continue operation.<br \/>\n<\/code><\/p>\n<p>This particular error <code> \/usr\/sbin\/mysqld: Can't find file: '.\/mysql\/plugin.frm' (errno: 13)<\/code> led me to a lot of posts about apparmor, i shut off iptables but the winner was SELINUX.<br \/>\nsetenforce 0<br \/>\nthen mysql started right up!<br \/>\n<a href=\"http:\/\/www.electrictoolbox.com\/switch-off-selinux-centos-5\/\">shut it off for good,<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While trying to set up a new MySQL slave on Centos 5, i copied over the \/var\/lib\/mysql directory and made necessary updates but Mysql would not start, in \/var\/log\/mysql.log there was this 120910 13:40:00 mysqld_safe mysqld from pid file \/var\/lib\/mysql\/omni1.omniweb.com.pid &hellip; <a href=\"https:\/\/www.omniweb.com\/wordpress\/?p=710\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/710"}],"collection":[{"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=710"}],"version-history":[{"count":2,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/710\/revisions"}],"predecessor-version":[{"id":721,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/710\/revisions\/721"}],"wp:attachment":[{"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.omniweb.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}