SElinux开启导致mysql 5.5.x移动数据库目录报错

一. 环境描述

       1. 系统版本: CentOS release 6.5 (Final)

       2. 内核版本: 2.6.32-431.el6.x86_64

       3. mysql版本: MySQL-server-5.5.27-1.rhel5.x86_64

       4. mysql客户端版本: MySQL-client-5.5.27-1.rhel5.x86_64

二. 移动数据库过程及报错:

       1. 通过RPM方式安装,默认安装目录是/var/lib/mysql

       2. 在/home下创建database: mkdir /home/database

              默认的属主,属组是root, 权限drwxr-xr-x.

       3. 将/var/lib/mysql移动到/home/database/ 之下

       3. 添加 /etc/my.cnf

              [client]

              port=3306

              socket=/home/database/mysql/mysql.sock

 

              [mysqld]

              port=3306

              socket=/home/database/mysql/mysql.sock

              datadir=/home/database/mysql

 

       4. 启动mysql报错:

              /etc/init.d/mysql start

              Starting MySQL.The server quit without updating PID file                   (/home/database/mysql/master.mysql.com.pid).

             

              报错的含义: mysql启动, 不能更新PID而退出.

 

       5.  查看selinux 是否打开

              [root@master ~]# sestatus

              SELinux status:                 enabled

              SELinuxfs mount:                /selinux

              Current mode:                   enforcing

              Mode from config file:          enforcing

              Policy version:                 24

              Policy from config file:        targeted

             

              6. 禁用selinux

                     vim /etc/selinux/config

                     SELINUX=enforcing 改为 SELINUX=disabled

                     重启系统: reboot

      

              7. 重启mysql正常

              [root@master ~]# /etc/init.d/mysql restart

              Shutting down MySQL.                          [  OK  ]

              Starting MySQL..                                 [  OK  ]

 

              8. 注意: 如果不是移动而是复制, 需要修改mysql目录的权限

 

                     chown -R mysql.mysql /home/database/mysql

                     chmod -R 755 /home/database/mysql

 

                     切换到mysql的身份新建一个文件,测试读写权限