mysql5.7修改binlog日志位置

/etc/mysql/mysql.conf.d/mysqld.cnf

log-bin=/data/mysql-binlog/binlog
log-bin-index=/data/mysql-binlog/binlog.index
server-id=2
expire_logs_days = 7

error:

mysqld: File '/data/mysql-binlog/binlog.index' not found (Errcode: 13 - Permission denied)

resolve:

# chown mysql.mysql /data/mysql-binlog/ -R

# vim  /etc/apparmor.d/usr.sbin.mysqld
    # Allow data dir access  #添加新的路径到此项下
    /var/lib/mysql/ r,
    /var/lib/mysql/** rwk,
    /data/mysql-binlog/ r,     
    /data/mysql-binlog/** rwk,
# systemctl restart apparmor.service 
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。