centos7 修改MySQL默认存储路径

由于MySQL的数据量过大，导致MySQL默认存储路径的磁盘满了，故整理出此教程，一方面是自己留作笔记，另一方面希望对大家有所帮助。

Centos7下安装MySQL5.7

1. 在home目录下创建data目录作为默认路径

   [root@localhost /]# mkdir /home/data
   [root@localhost /]# cd /home/data/
   [root@localhost data]#
   

2. 关掉MySQL的服务进程（需要输入密码）

   [root@localhost data]# mysqladmin -u root -p shutdown
   Enter password:
   

3. 把/var/lib/mysql整个目录移到/home/data下

   [root@localhost data]# mv /var/lib/mysql /home/data/
   [root@localhost data]# 
   

   或者

   [root@localhost data]# cp -R /var/lib/mysql /home/data/
   [root@localhost data]# 
   

4. 设置/home/data/下mysql文件夹的主属和权限

   [root@localhost data]# chown -R mysql:mysql /home/data/mysql
   [root@localhost data]# ll
   总用量 0
   drwxr-x--x 6 mysql mysql 328 10月 22 18:36 mysql
   [root@localhost data]# 
   

5. 修改配置文件/etc/my.cnf

   [root@localhost data]# vim /etc/my.cnf
   

   按照下边的内容修改参数

   [mysqld]
   #datadir=/var/lib/mysql
   datadir=/home/data/mysql
   #socket=/var/lib/mysql/mysql.sock
   socket=/home/data/mysql/mysql.sock
   
   [client]
   default-character-set=utf8
   socket=/home/data/mysql/mysql.sock
   
   [mysql]
   default-character-set=utf8
   socket=/home/data/mysql/mysql.sock
   

   

6. SELINUX 设置

   [root@localhost data]# vim /etc/selinux/config
   

   把SELINUX的参数修改成disabled即可：
   

7. 重新启动MySQL服务（只需输入下边的启动命令即可）

   systemctl restart mysqld.service  #重启
   systemctl start mysqld.service  #启动
   systemctl stop mysqld.service #停止
   service mysqld status #查看状态
   

8. 登录测试一下

   [root@localhost data]# mysql -uroot -p
   Enter password: 
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 3
   Server version: 5.7.28 MySQL Community Server (GPL)
   
   Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>