mysql5.7修改数据目录

最新推荐文章于 2024-06-14 14:05:19 发布

could9

最新推荐文章于 2024-06-14 14:05:19 发布

阅读量1k

点赞数 1

文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/could9/article/details/121036101

版权

本文详细指导如何在Mysql中创建新的数据目录，修改配置文件，适应AppArmor规则，并重启服务，确保数据迁移成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Mysql修改数据目录

一、创建数据目录

mkdir /data/var/lib/mysql
chown -R mysql:mysql /data/var/lib/mysql
cp -r /var/lib/mysql/** /data/var/lib/mysql

二、修改/etc/mysql/mysql.conf.d/文件

将datadir设置为/data/var/lib/mysql

三、修改/etc/apparmor.d/usr.sbin.mysqld文件

文件内容：

# vim:syntax=apparmor
# Last Modified: Tue Feb 09 15:28:30 2016
#include <tunables/global>

/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>

# Allow system resource access
  /proc/*/status r,
  /sys/devices/system/cpu/ r,
  /sys/devices/system/node/ r,
  /sys/devices/system/node/** r,
  capability sys_resource,
  capability dac_override,
  capability dac_read_search,
  capability setuid,
  capability setgid,

# Allow network access
  network tcp,

  /etc/hosts.allow r,
  /etc/hosts.deny r,

# Allow config access
  /etc/mysql/** r,

# Allow pid, socket, socket lock file access
  /var/run/mysqld/mysqld.pid rw,
  /var/run/mysqld/mysqld.sock rw,
  /var/run/mysqld/mysqld.sock.lock rw,
  /run/mysqld/mysqld.pid rw,
  /run/mysqld/mysqld.sock rw,
  /run/mysqld/mysqld.sock.lock rw,

# Allow systemd notify messages
  /{,var/}run/systemd/notify w,

# Allow execution of server binary
  /usr/sbin/mysqld mr,
  /usr/sbin/mysqld-debug mr,

# Allow plugin access
  /usr/lib/mysql/plugin/ r,
  /usr/lib/mysql/plugin/*.so* mr,

  /data/usr/lib/mysql/plugin/ r,
  /data/usr/lib/mysql/plugin/*.so* mr,

# Allow error msg and charset access
  /usr/share/mysql/ r,
  /usr/share/mysql/** r,

# Allow data dir access
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,

  /data/var/lib/mysql/ r,
  /data/var/lib/mysql/** rwk,
# Allow data files dir access
  /var/lib/mysql-files/ r,
  /var/lib/mysql-files/** rwk,

# Allow keyring dir access
  /var/lib/mysql-keyring/ r,
  /var/lib/mysql-keyring/** rwk,

# Allow log file access
  /var/log/mysql.err rw,
  /var/log/mysql.log rw,
  /data/var/log/mysql.log rw,
  /data/var/log/mysql.err rw,



  /var/log/mysql/ r,
  /var/log/mysql/** rw,

# Allow read access to OpenSSL config
  /etc/ssl/openssl.cnf r,
  # Site-specific additions and overrides. See local/README for details.
  #include <local/usr.sbin.mysqld>
}

四、启动

/etc/init.d/apparmor restart

/etc/init.d/mysql restart

五、结果展示