centos7 mysql5.7.32 修改存储位置

系统版本centos7.6    mysql版本 5.7.32

安装过程：

#!/bin/bash

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
systemctl start  mysqld.service

# 进入数据库 修改密码即可使用

# 查看默认密码
grep "password" /var/log/mysqld.log
alter user 'root'@'localhost' identified by 'New@passwd123';

# 记得关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
setenforce 0

# 关闭mysql服务

mysqladmin -u root -p shutdown

# 复制mysql原位置到新目录 

mkdir -p /home/data
cp -arp /var/lib/mysql /home/data/

 

#  修改 my.cnf配置文件

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[client]
#客户端设置
port    = 3306
socket    = /home/data/mysql/mysql.sock  # 这个目录和下面相同
#default-character-set = utf8mb4
[mysqld]
#
# 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=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/home/data/mysql  # 迁移后的路径
socket=/home/data/mysql/mysql.sock   #迁移后的路径
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# 重启mysql服务

systemctl restart mysqld

# 启动后查看mysql存储位置

mysqladmin -u root -p variables | grep datadir

 

# 删除原来的目录 如果是zabbix 最好在给个软链接

rm -rf /var/lib/mysql
ln -s /home/data/mysql/mysql.sock  /var/lib/mysql/mysql.sock