Ubuntu mysql的binlog只能放在/var/log/mysql下

Question

mysql5.7 ubuntu16.4
binlog只能放在mysql配置文件默认的/var/log/mysql下，将路径修改为其他位置则提示权限不足
属主属组权限都给了myql，目录改为了777，依旧不行

/var/log/mysql目录权限

root@ubuntu:/var/log/mysql# ll /var/log/mysql/
total 208
drwxr-x--- 2 mysql adm      4096 Jul 25 11:51 ./
drwxrwxr-x 7 root  syslog   4096 Jul 25 10:08 ../
-rw-r----- 1 mysql adm    177095 Jul 25 11:51 error.log
-rw-r----- 1 mysql mysql     177 Jul 25 11:39 mysql-bin.000001
-rw-r----- 1 mysql mysql     177 Jul 25 11:44 mysql-bin.000002
-rw-r----- 1 mysql mysql     177 Jul 25 11:49 mysql-bin.000003
-rw-r----- 1 mysql mysql     154 Jul 25 11:51 mysql-bin.000004
-rw-r----- 1 mysql mysql     128 Jul 25 11:51 mysql-bin.index

属主属组完全相同但是还是报错

2019-07-25T03:50:31.499690Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:50:31.499875Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:50:31.678797Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:50:31.681269Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22722 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:50:31.685861Z 0 [ERROR] Aborting

2019-07-25T03:50:31.685940Z 0 [Note] Binlog end
2019-07-25T03:50:31.686079Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-07-25T03:50:46.822469Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:50:46.822565Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:50:47.029772Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:50:47.032072Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22773 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:50:47.037520Z 0 [ERROR] Aborting

2019-07-25T03:50:47.037610Z 0 [Note] Binlog end
2019-07-25T03:50:47.037763Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-07-25T03:51:17.533526Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:51:17.533655Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:51:17.791165Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:51:17.793337Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22853 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:51:17.798406Z 0 [ERROR] Aborting

2019-07-25T03:51:17.798466Z 0 [Note] Binlog end
2019-07-25T03:51:17.799262Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Answer 1

根据您提供的错误日志和描述，看起来是文件权限问题。尝试使用chmod命令更改新目录的文件权限。可以执行以下命令：

sudo chmod -R 777 /path/to/new/directory

务必将“/path/to/new/directory”替换为您想要放置binlog的目录的实际路径。如果仍然无法正常工作，请检查mysql用户的UID和GID是否匹配您的系统，是否有任何SELinux限制，以及尝试重启MySQL服务。