Linux修改mysql数据库目录（多实例仅修改单个实例）

1停止数据库

启动全部实例：/usr/local/mysql/bin/mysqld_multi start
查看全部实例状态：/usr/local/mysql/bin/mysqld_multi report
启动单个实例：/usr/local/mysql/bin/mysqld_multi start 7001
停止单个实例：/usr/local/mysql/bin/mysqld_multi stop 7001
查看单个实例状态：/usr/local/mysql/bin/mysqld_multi report 7001

【如果关不掉数据库的话，使用如下语句】
mysqladmin -h127.0.0.1 -P7001 -uroot -p shutdown
↓↓报错的话↓↓

    WARNING: my_print_defaults command not found.
    Please make sure you have this command available and
    in your path. The command is available from the latest
    MySQL distribution.
    ABORT: Can't find command 'my_print_defaults'.
    This command is available from the latest MySQL
    distribution. Please make sure you have the command
    in your PATH.
----------------------------------------------------------------------
    【解决办法】
    export PATH=/usr/local/mysql/bin:$PATH

2复制mysql目录

注意操作权限
首先进入到安装的文件夹，之后使用命令复制文件到data目录下
【cp -a mysql7 /data/】
cp -arp：保持权限复制

3修改三个文件

1. /etc/my.cnf

   datadir=/data/mysql7001/data
   socket=/data/mysql7001/data/mysql.sock
   

2. /etc/init.d/mysqld

   datadir=/data/mysql7001/data
   

3. /usr/bin/mysqld_safe

   DATADIR=/data/mysql7001
   

4建立软连接

ln -s /data/mysql7001/data/mysql.sock /usr/local/mysql/data/mysql.sock

5启动MySQL

参考第1步