Mysql修改datadir导致无法启动问题解决方法

centos6.2，停止mysqld然后修改/etc/my.cnf datadir的位置，启动mysqld提示FAILED，查看日志

相关mysql视频教程推荐：《mysql教程》

代码如下:

<br><p></p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>120609 11:31:31 </li><li>mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 120609 11:35:12 mysqld_safe Starting mysqld daemon with data</li></ol></pre><p> centos6.2，停止mysqld然后修改/etc/my.cnf datadir的位置，，启动mysqld提示FAILED，查看日志</p><p>代码如下:</p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>120609 11:31:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended120609 11:35:12 mysqld_safe Starting mysqld daemon with databases from /mnt/hgfs/mysql_data120609 11:35:13 [Warning] Can't create test file /mnt/hgfs/mysql_data/data.lower-test120609 11:35:13 [Warning] Can't create test file /mnt/hgfs/mysql_data/data.lower-test/usr/libexec/mysqld: Can't change dir to '/mnt/hgfs/mysql_data/' (Errcode: 13)120609 11:35:13 [ERROR] Aborting</li><li> </li><li>120609 11:35:13 [Note] /usr/libexec/mysqld: Shutdown complete</li><li>120609 11:35:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended</li></ol></pre><p>新的datadir路径确实没问题，而且目录和目录下所有文件都是777权限，上层目录也有rx权限，只不过datadir和下属文件owner都是root（因为我用虚拟机挂载的windows的文件系统）。后来想到应该是selinux搞的鬼，设置为permissive模式之后正常启动mysqld。</p><p>代码如下:</p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>[root@data selinux]# getenforce</li><li>Enforcing</li><li>[root@data selinux]# setenforce 0</li><li>[root@data selinux]# getenforce</li><li>Permissive</li></ol></pre><p>setenforce 1 设置SELinux 成为enforcing模式<br>setenforce 0 设置SELinux 成为permissive模式</p><p>彻底关闭，vi /etc/selinux/config 修改 SELINUX=disabled</p><p>代码如下:<br></p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li># This file controls the state of SELinux on the system.</li><li># SELINUX= can take one of these three values:</li><li>#     enforcing - SELinux security policy is enforced.</li><li>#     permissive - SELinux prints warnings instead of enforcing.</li><li>#     disabled - No SELinux policy is loaded.</li><li>SELINUX=disabled</li><li># SELINUXTYPE= can take one of these two values:</li><li>#     targeted - Targeted processes are protected,</li><li>#     mls - Multi Level Security protection.</li><li>SELINUXTYPE=targeted</li></ol></pre>