修改log_bin路径后数据库无法启动

来源:5-2 mysql主从复制演示

宝慕林2132329

2020-02-02

mysql启动时报错,my.cnf中log_bin设置为默认路径,数据库启动正常,但更改目录后启动报如下错,目录的权限已经是777,文件归属为mysql:mysql,请大归帮分析是什么原因!
2020-02-01T15:30:44.754616Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-02-01T15:30:44.755065Z 0 [Warning] Can’t create test file /mysql/data/rep2.lower-test
2020-02-01T15:30:44.755154Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-log) starting as process 14254 …
2020-02-01T15:30:44.762014Z 0 [Warning] Can’t create test file /mysql/data/rep2.lower-test
2020-02-01T15:30:44.762061Z 0 [Warning] Can’t create test file /mysql/data/rep2.lower-test
mysqld: File ‘/mysql/log/bin.index’ not found (Errcode: 13 - Permission denied)
2020-02-01T15:30:44.765756Z 0 [ERROR] Aborting

my.cnf配置如下
[mysqld]
server_id=201
#log_bin=/var/lib/mysql/master-bin
log_bin=/mysql/log/bin
#gtid_mode=on
#enforce-gtid-consistency=on
datadir=/mysql/data
socket=/var/lib/mysql/mysql.sock
relay_log=/mysql/rellog/relay-bin
#master_info_repository=table
#relay_log_info_repository=table

[root@rep2 /]# ls -ls /mysql/
total 4
4 drwsrwsrwt. 5 mysql mysql 4096 Feb 1 23:22 data
0 drwsrwsrwt. 2 mysql mysql 41 Feb 1 23:22 log
0 drwsrwsrwt. 2 mysql mysql 6 Feb 1 22:53 rellay

[root@rep2 mysql]# ls -l
total 4
drwsrwsrwt. 5 mysql mysql 4096 Feb 1 23:22 data
drwsrwsrwt. 2 mysql mysql 6 Feb 1 23:30 log
drwsrwsrwt. 2 mysql mysql 6 Feb 1 22:53 rellay

写回答

1回答

sqlercn

2020-02-02

看错误还是没有写权限,你看一下目录下的文件的所有者是否是mysql用户?

0
0

高性能可扩展MySQL数据库设计及架构优化 电商项目

从基础设计入手,设计高性能可扩展的千万级数据库架构

1155 学习 · 166 问题

查看课程