ubuntu22.04安装mysql8.0,在修改数据文件位置时,已经进行如下操作:
1.创建新的目录和复制文件 sudo rsync -a /var/lib/mysql /data/
2.修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf的datadir
3.修改/etc/apparmor.d/usr.sbin.mysqld的以下属性
# Allow data dir access
/data/mysql/ r,
/data/mysql/** rwk,
4.修改控制文件/etc/apparmor.d/abstractions/mysql 如下:
/data/mysql{,d}/mysql{,d}.sock rw,
5.重启systemctl restart apparmor 没有报错
6.重启mysql报错
报错信息如下:
× mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2023-08-07 16:30:52 CST; 12s ago
Process: 141558 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 141566 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Main PID: 141566 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
Error: 13 (权限不够)
CPU: 319ms
参考了https://blog.csdn.net/yuanjiaqi_k/article/details/130271526,还是不行
请各位帮助
chmod -R 755 /data
chown -R mysql.mysql /data/mysql
执行这两条语句赋下权限
lsattr /data看看还有没有隐藏的权限问题