1、查看MySQL/MariaDB数据库的数据目录

MariaDB [(none)]> select @@datadir;

+-----------------+

| @@datadir       |

+-----------------+

| /var/lib/mysql/ |

+-----------------+

1 row in set (0.00 sec)

MariaDB [(none)]>

所以数据目录是 /var/lib/mysql/

2、停止数据库

systemctl stop mariadb

3、创建新的数据目录

mkdir /data/mysql

chmod 777 /data/mysql/

复制文件到数据存放目录

cp -a /var/lib/mysql/* /data/mysql/

编辑

vim /etc/my.cnf

[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
character-set-server=utf8
[client]
socket=/data/mysql/mysql.sock
default-character-set=utf8

4、目录给mysql用户权限

chown -R mysql:mysql /data/mysql/

5、启动数据库

systemctl restart mariadb