mysql5.6数据库安装并更改存储目录步骤

mysql5.6数据库安装并更改存储目录步骤

一、环境安装

首先需要rpm包以及基础环境
mysql-community-release-el6-5.noarch.rpm
博主分享rpm包
yum -y install gcc automake autoconf libtool make gcc-c++ pcre-devel zlib-devel openssl-devel wget vim

二、安装mysql

安装rpm包

rpm -ivh mysql-community-release-el6-5.noarch.rpm

yum安装mysql

yum install mysql-community-server -y

mysql安装完成

三、配置mysql

首先启动mysql

service mysqld start

设置密码及安全规则

mysql_secure_installation

这一步骤我只修改了密码，其它安全规则根据需求修改

修改配置文件（这里我修改的为/home目录下）

datadir=/home/mysql
socket=/home/mysql/mysql.sock

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]
character_set_server=utf8
max_allowed_packet = 512M
innodb_log_file_size = 512M
federated
event_scheduler = 1

#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/home/mysql
socket=/home/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

将原目录下的所有文件copy到 /home下面

cp -rp /var/lib/mysql /home/

这里注意需要拷贝所有的文件包括相对应的权限

在做一下软链接，否则会出现启动不了的情况

ln -s /home/mysql/mysql.sock /var/lib/mysql/mysql.sock

最后冲洗一下mysql

service mysqld restart

四、注意情况

在这里可能会出现无法启动的情况，还要配置一下selinux，然后重启机器

vi /etc/selinux/config
将selinux配置为disabled，当然，有其它需求的可以自己配置规则

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

重启服务后再启动mysql就可以啦~