Linux 中改变 MySQL8 数据库存储路径

1. 安装 MySQL8

链接:
https://blog.csdn.net/YKenan/article/details/100606824

2. 查看 MySQL8 的数据存储路径

show global variables like "%datadir%";

结果:

2. 停止 MySQL 服务

systemctl stop mysqld

3. 移动数据存储路径到指定位置

mv /var/lib/mysql /mnt/mysql_wp/

4. 建立软链接

ln -s /mnt/mysql_wp/mysql /var/lib/mysql

5. 查看软连接状态

ls -la /var/lib/mysql

6. 修改配置文件

vim /etc/my.cnf

文件修改内容, 保存文件

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

[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 the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_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
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password

datadir=/mnt/mysql_wp/mysql
socket=/mnt/mysql_wp/mysql/mysql.sock

log-error=/mnt/mysql_log/mysqld.log
pid-file=/mnt/mysql_run/mysqld/mysqld.pid

[client]
socket=/mnt/mysql_wp/mysql/mysql.sock

[mysql]
socket=/mnt/mysql_wp/mysql/mysql.sock

7. 授权路径

chown mysql:mysql -R /mnt/mysql_wp/mysql

8. 重启 MySQL

systemctl start mysqld

9. 查看存储路径

show global variables like "%datadir%";

结果: